@LutzM:

I'll try to find out. I don't know alot about what happened because the "acquiring company" tried to upgrade to 2008 R2 before our...

Wow, great question. First, before I give my input, a little background on myself might help:

My background is primarily in SQL Server 2000+ data warehousing (both relational and "cube"/dimensional)....

Itzik uses RECURSION, even faster.

With nums as

(

Select 1 as n

Union all

Select n+1 from nums where n < 10

)

Select n

From nums