SQL - Merge

[@safkaify7875]

Probably the best teaching video I've seen in terms of: Visuals + well paced script + audio on point. Please keep up the good work.

[@chriskeo392]

Crushed it Visuals + well paced script + audio on point 👑 Content king!

[@ottmiller4028]

James, your explanations are lucid and thorough. Thank you for your efforts.

[@kristeenahbro]

I watched this today while I was stuck trying to use merge for the first time at work. I looked up this video on my phone just to say thank you!!! I can't post youtube comments from my work pc but I wanted to say great vid 😊

[@Circumvenscion]

Well explained and concise. Please do more of these type of videos, you're great at it!

[@JamesOliver]

Thank you for the kind words. Much appreciated. :)

[@briancanfield2968]

Agreed

[@cidaiha]

Thank you, PERFECT EXPLANATION !

[@hklbly]

Crystal clear explanation, thanks!

[@CrazySw3de]

Great video, easy to understand explanation with clear examples and nice editing.

[@apoorvavanaparthi8853]

Thank you so much for this clear and concise explanation!!!!!!! 🙏

[@Thle009]

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?

[@anawadtom6011]

Simple, clear explanation. Thanks!

[@RC-ql5lp]

Great tutorial. I have learn a new command in t-sql.

[@abbasmuhammed214]

thank you so much, I appreciate that, and it was very useful

[@maheshbabu6925]

Nice explanation James

[@JamesOliver]

Appreciate it very much. :)

[@bobocrazvan-marius801]

Very helpful video, thank you for the explanation!

[@abcxyz6606]

Wow, this is very neat. TY for these.

[@chriskeo392]

More advanced merge videos?!? And more on how to leverage OUTPUT

[@sayfriseup172]

Any Idea about 'Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "French_CI_AS" in the equal to operation.

[@iliashterev38]

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.

[@makeittrades5750]

wow what a cool tutorial, loved it!

[@mohammadhaque1873]

Thank you, very nicely explained.

[@RainSoundsToConcentrate]

Amazing video ,ty 😎

[@emrc9777]

Excellent video! ❤

[@rntech4541]

thanks so much sir. This Solved my proble which made me busy with it since a week,,but could you tell me how to invite this query in c#?

[@sumit-visatotravel8780]

Very well explained!

[@LearnSalesforceWithPiyush]

How to merge two stored procedures in mysql.

[@sreelakshmia6762]

Do you have same in oracle?

[@rapo107]

James... Missing your MSTR videos a lot. Please make videos..🙏

[@JamesOliver]

MicroStrategy video coming Monday

[@fo1487]

I liked your video, ty

[@henrygrip8486]

Why did the result showed you the row with the id 1524 when that one doesnt exist in either of the two original tables.

[@romeokamil]

hi did select on top 7 from source table, 1524 was not in top 7 but matched the values for the merge.

[@PedramRasti]

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

[@tihanapolezari7638]

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. 😄

[@MpT_Head]

@@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.

[@Raj-ph1py]

Excellent tutorial

[@JamesOliver]

Much appreciated. :)

[@johnli6706]

Nice presentation, but you missed the update when only CreditRating changes.

[@riccarrasquilla379]

thanks for the video

[@FloKluge]

Cool video, but the merge did not update a rating change from 1 to 2 or from 2 to 1.

[@thomasjordan454]

Awesome video thanks

[@romeokamil]

wow, they were very quick 10 minutes :)

[@dmitryvlasov931]

Good job!

[@harshalpatel555]

Hey James How do i get this script to practise

[@JamesOliver]

Let me check if I can find it

[@Renad-bm3ph]

thank you angel

[@israell9320]

Awesome!! thanks

[@TheSomestuffs]

Good...

[@thedatastoryteller5692]

Tech people can learn to actually ARTICULATE from you as they need your coaching. I work with tech people and NEVER understand their explantions.