Home Forums SQL Server 2005 T-SQL (SS2K5) Temp Table 'vs' Table Variable 'vs' CTE. RE: Temp Table 'vs' Table Variable 'vs' CTE.

  • July 1, 2009 at 12:08 pm

    #1018633

    Hello ,

    CTE really improves performance as always in most cases. I would prefer to use CTE over Temp tables.

    BHARGAV PATEL

    yobhargav@yahoo.com