There are many ways to do this (tally table as suggested by Arjun, recursive CTE, EXCEPT) here is a demonstration of one of these possible methods (EXCEPT):

-- For demonstration purposes...

I looked for that too - my...

Someone just quoted a reference at me on a thread to prove that table variables are faster than real temporary tables. The relevant extract from the 'reference' is:

"Temp tables...

swati-1123102 (3/31/2010)

---

I used this query

SELECT COUNT(*) comp_qprob_data

and it returned the result as 1

If you look at the query you will find that syntactically it is wrong. Have missed the...

...which is complete nonsense. 😛

Sunil Agarwal is a Program Manager in the SQL Server Storage Engine Group at Microsoft, read his views on the SQL...

Parallelism can be vital to good performance for some types of queries, so it is worthwhile spending some time reading up to appreciate the issues involved. Some of the...

Glad someone does 🙂

Amusing 😎

Exactly my reaction when I first looked at your Connect item! I have added it to my watch list.

Thanks, Hugo.

Thank you for the detailed feedback - it is appreciated!

Paul

Lynn Pettis (3/31/2010)

---

GilaMonster (3/31/2010)

---

That's an evil question to ask.... So many ways...

If the SQL Server execution time is effectively zero, that's a good hint that the issue lies elsewhere 🙂

Network latency springs to mind, but yes - consider batching and streaming.

See...

george sibbald (3/31/2010)

---

There is no difference in maximum possible database size with standard and enterprise editions so people run some quite large dbs with standard. (my largest is is 300Gb)

Anyway,...

Thanks, everyone. Glad I am not the only one to find this whole area fascinating.

Hugo Kornelis (2/26/2010)

---

I'll raise the red flag (if I only knew how to get red text here):

THIS METHOD IS NOT DOCUMENTED, NOT SUPPORTED, AND NOT GUARANTEED TO RETURN WHAT YOU...