Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Srinivas Sampath Common Table Expressions in SQL Server 2005 RE: Common Table Expressions in SQL Server 2005

  • March 2, 2006 at 9:19 am

    #624346

    Another option is to use a table variable, populate it with data, then you can reference it multiple times.  Perhaps not as fast as a CTE (I don't have SS 2005 to test), but available in SS 2000.