• Good Point Homebrew - It is a better practice in most cases to create the table first.

    If all is broken currently because nothing can be inserted into the table, then it may be fine in this scenario to use the select into.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events