Thank you for a great tutorial video. The fact that it is still relevance today 2 years later showing just how powerful your video is. Would it be possible for you to make a video on the output and the MergeResults table?
I was just about to say this tutorial is awesome and then you went onto the deleted and inserted tables without taking a moment to walk trough the target table after the merge. And I have learned so far that deleted and inserted tables are available only within the scope of the triggers. Which confused me further.
Thank you James! Any idea why a syntax error near the OUTPUT may come up. I did exactly what you did but somehow for the output part i get a syntax error
Because you need to create a new table or temporary table with CREATE statement which contains fields from both tables, including the field for Action. Let's say that target and source have next table structure: BusinessEntityID int, AccountNumber nvarchar(10), Name nvarchar(10), CreditRating int I need to create table #MergeResults like: Create table #MergeResults (BusinessEntityID int, AccountNumber nvarchar(10), Name nvarchar(10), CreditRating int, ActionTaken nvarchar(10), new_BusinessEntityID int, new_AccountNumber nvarchar(10), new_Name nvarchar(10), new_CreditRating int) then the last statement or OUTPUT deleted.*., $action, inserted.* into #MergeResults will work. Hope it will help someone. 😄
@@tihanapolezari7638 This did help a lot, thanks. James probably should have shown the temp #MergeResults table and also explained how the Output works to put the old and the new data in the correct columns. I haven't really worked with Triggers before so when he said 'If you've worked with Triggers before...' it was remiss not to explain for those who hadn't.