Jeff Moden (8/18/2013)
Even if it coud be done efficiently, I'd still like to know why someone is building a result set that contains 20 million rows.
So Curious_sqldba did mention that he also ran the query in SSIS. I assume that he exporting the data. For which, of course, SSMS is not a good tool.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]