Home Forums SQL Server 2008 T-SQL (SS2K8) Convert the stored procedure to "Standard SQL Select" RE: Convert the stored procedure to "Standard SQL Select"
halifaxdal
SSCoach
Points: 19741
More actions
April 13, 2014 at 2:08 pm
#1705612
Lynn Pettis (4/13/2014)As much as I hate saying this, since semicolons are statement terminators not statement begininators, try putting a semicolon in front of the WITH of the CTE declaration. I.E. ;with ... .
Lynn Pettis (4/13/2014)
Thank you, that's a good point.