• Works well in SQL Server 2005, but doesn't in 2000 which returns the error:

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

    Apparently 2000 doesn't allow the output of a stored procedure to be inserted to a table variable. Would be good to have mentioned this in the article, and would be even better if a solution was suggested!