The warning prettry much says it all. Apparently you have a join hint in the query (I can't verify that since you didn't post the query), and this is only a warning that one want to keep number of such hints down to a minimum. So, either remove that join hint, or just live with and ignore that warning.
Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi
- Proposed as answer by Naomi NModerator Friday, October 31, 2014 7:12 PM
Here is the query
KUN.NK_KUN, KUN.KUNDE_TP, FAC.VALUE, HIE.SK_CSIHIE, HIE.L2_NK, FAC.SK_TID
JOIN DBO.LHFSOORGMEDTEAKUN_L KUN
ON FAC.SK_KUNGRP = KUN.SK_KUNGRP
ON FAC.SK_CSIHIE = HIE.SK_CSIHIE
Are other of those two objects views ? Im guessing that at least one is .
Dave Ballantyne ---- http://sqlandthelike.blogspot.com