Ken, totally makes sense. I'll pass this info off to our Junior Devs.

Thanks for the expedited reply

Thanks for this great article, It just so happens i had been training up our Junior developers on using the output clause on a merge statement so this adds extra...

for anyone interested this is a part of the solution that i can share

DECLARE @t TABLE (id INT IDENTITY PRIMARY KEY,tbl_name VARCHAR(100))

DECLARE @id INT,

...