Home Forums SQL Server 2008 SQL Server 2008 - General CTE and inner join RE: CTE and inner join

  • January 11, 2011 at 12:26 pm

    #1272032

    The CTE "belongs" to the query, not the session.

    IOW, if you want to persist it for the entire session you will not be able to use a CTE - you could use a table variable or temp table

    jg