Home Forums SQL Server 2008 T-SQL (SS2K8) How to create a temp table in a procedure rather than usinh INTO #temptable RE: How to create a temp table in a procedure rather than usinh INTO #temptable

  • April 19, 2014 at 3:07 pm

    #1707292

    gbritton1 (4/16/2014)

    Well, the fix is not complete. I ran into this again in SQL Server 2008R2 just last year. I applied my workaround and voila! Lock gone.

    Do you happen to remember what the code was doing during the SELECT/INTO?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)