Home Forums SQL Server 2005 T-SQL (SS2K5) CTE RE: CTE
Lynn Pettis
SSC Guru
Points: 442467
More actions
April 14, 2010 at 1:33 pm
#1151683
ychen 55059 (4/14/2010)Would the 'into #tbl ' above suffice? I wanted to be consistent with the #tbl referenced in the CTE query.
ychen 55059 (4/14/2010)
It works, just not the way you should do it. It would be better to separate your DDL from the load of your data.