• ScottPletcher (10/23/2014)


    For temp tables, you must also consider:

    INTO #new_temp_table

    rather than just CREATE.

    Good point! I try to stop people doing that in production code, but a few get through the net.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin