I know this is a beginner question and Im a bit ashamed to even ask but....I need to know the syntax for a query hint. The help seems a bit confusing to me with all those brakects and squgily lines. Can some one give me a simple example of using a query hint?
Originally posted by ispaleny
group by id
option (hash group)
Thanx for the fast reply man...one more fast question. The option command is it always after the group by or is it the last thing in the query. Im asking because I have a having clause, do I put the option clause before or after the having?