• thanks for the response.

    Yes I am going to have to use a temp table as our DBA area frowns upon lots of "staging" tables in the database.