Thanks!

I figured out where OUTPUT goes but it doesn't help on the production database.

update ACS set ACS.Contract_Start_Date = zzp.start output inserted.Alarm_Account

FROM table1...

Where would an output clause fit into this query? BOL is, as usual, 99% incomprehensible. I want to output ACS.Alarm_Account into table3 ?

(table3 does not yet exist, I'm...

Thanks... is there a join type that will support a one-to-many update, if only to mark the occurrences in the original file as rejects? So far google searches haven't...

THANKS for looking at it and... I mis-spoke. My spreadsheet has 569 rows... saw the 0 as a 9. Yes, there's a 1-to-many relation between table1 and table2....

We're doing pretty much the same thing here - it just depends on what the user of the information will accept. On my first pass through this I also...

THANKS! 😀

That got me almost there. The result was still dropping rows where the employee number didn't exist in the table that inner joined SY_Employee. It occurred...