haha thanks for your help. I appreciate it.

Wow what a pain.. Thanks for your suggestion though, what do you think would scale better, that or using a cursor?

Yeah that would work, the duplicate data is not a problem but i can't add another column to the table 🙁

Cool, so any ideas on how to solve this one? I could do it with a cursor but that would suck i'm sure there is an easier way.

I'm not sure if i understand, i'm not updating or deleting from any tables i'm only inserting new records, so how would i have access to DELETED.* values?