• That was a cool, tricky question.

    I got this in Query Analyzer (SQL 2000):

    Server: Msg 170, Level 15, State 1, Line 2

    Line 2: Incorrect syntax near 'GO'.

    Server: Msg 170, Level 15, State 1, Line 2

    Line 2: Incorrect syntax near 'GO'.

    but the code given did work in SSMS.

    Thanks,

    werbunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html