• Unfortunately I'm still on SQL 2000 so I get the following error:

    Server: Msg 197, Level 15, State 1, Line 12

    EXECUTE cannot be used as a source when inserting into a table variable.