Insert and Update Data With Merge Statement In MS SQL Server

[@Krazy_Shorts]

Oh wow, didn't realize there was an OUTPUT option on the MERGE command. pretty handy!

[@youngjuggler]

This is great thank you so much! I love how much you prove your work and code.

[@pahaadi_soul]

Hey Jen.. thanks for the info , could you please help me in understanding where I can use this in ssis, do i have to make a stored procedure and call this merge statement or should I write the merge statement in a sql task in ssis

[@MarleighShaw]

Hi, can you do one that troubleshoots when all the data you have defined in your insert statement doesn't correctly populate in the output on the second execution? It all correctly inserts on the first execution. However, on the second execution only one of those inserted values repopulates.

[@jiejenn]

In most cases, you will rollback if the output is different from what the expected.