Thanks for the suggestion. I will give that a shot. I never really like the idea of a loop but never thought of the OUTPUT option so thank...

No, all of the data comes from the one temporary table. I have the SCOPE_IDENTITY in there because it is constantly being used and I didn't want to put...