Koen Verbeeck (11/28/2012)
The only correct answer is 0.There are 8 statements in the estimated execution plan, but no queries.
From BOL:
A query is a request for data that is stored in SQL Server.
There isn't a single statement in the batch that does a request for data, hence no queries.
+1
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx