This video covers how to use the merge statement with t-sql.
Пікірлер: 51
@safkaify787523 күн бұрын
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!
@ottmiller40283 жыл бұрын
James, your explanations are lucid and thorough. Thank you for your efforts.
@cidaiha Жыл бұрын
Thank you, PERFECT EXPLANATION !
@Circumvenscion2 жыл бұрын
Well explained and concise. Please do more of these type of videos, you're great at it!
@JamesOliver2 жыл бұрын
Thank you for the kind words. Much appreciated. :)
@briancanfield29682 жыл бұрын
Agreed
@CrazySw3de3 жыл бұрын
Great video, easy to understand explanation with clear examples and nice editing.
@sumit-visatotravel87804 ай бұрын
Very well explained!
@anawadtom60112 жыл бұрын
Simple, clear explanation. Thanks!
@apoorvavanaparthi88536 ай бұрын
Thank you so much for this clear and concise explanation!!!!!!! 🙏
@RC-ql5lp3 жыл бұрын
Great tutorial. I have learn a new command in t-sql.
@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?
@abbasmuhammed214Ай бұрын
thank you so much, I appreciate that, and it was very useful
@iliashterev386 ай бұрын
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.
@RainSoundsToConcentrate9 ай бұрын
Amazing video ,ty 😎
@riccarrasquilla379Ай бұрын
thanks for the video
@mohammadhaque18732 жыл бұрын
Thank you, very nicely explained.
@bobocrazvan-marius8012 жыл бұрын
Very helpful video, thank you for the explanation!
@maheshbabu69252 жыл бұрын
Nice explanation James
@JamesOliver2 жыл бұрын
Appreciate it very much. :)
@abcxyz66063 жыл бұрын
Wow, this is very neat. TY for these.
@emrc9777 Жыл бұрын
Excellent video! ❤
@makeittrades57503 жыл бұрын
wow what a cool tutorial, loved it!
@sayfriseup172 Жыл бұрын
Any Idea about 'Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "French_CI_AS" in the equal to operation.
@Renad-bm3ph3 жыл бұрын
thank you angel
@thomasjordan4542 жыл бұрын
Awesome video thanks
@Raj-ph1py3 жыл бұрын
Excellent tutorial
@JamesOliver3 жыл бұрын
Much appreciated. :)
@chriskeo392 Жыл бұрын
More advanced merge videos?!? And more on how to leverage OUTPUT
@romeokamil2 жыл бұрын
wow, they were very quick 10 minutes :)
@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#?
@fo14872 жыл бұрын
I liked your video, ty
@DeekshaKatiyar-wn7ub Жыл бұрын
Hey I am facing issues in merge. Getting an error saying "Merge is not valid at this position"....
@sreelakshmia67623 ай бұрын
Do you have same in oracle?
@dmitryvlasov9313 жыл бұрын
Good job!
@israell93203 жыл бұрын
Awesome!! thanks
@LearnSalesforceWithPiyush2 жыл бұрын
How to merge two stored procedures in mysql.
@rapo1073 жыл бұрын
James... Missing your MSTR videos a lot. Please make videos..🙏
@JamesOliver3 жыл бұрын
MicroStrategy video coming Monday
@johnli6706 Жыл бұрын
Nice presentation, but you missed the update when only CreditRating changes.
@henrygrip84863 жыл бұрын
Why did the result showed you the row with the id 1524 when that one doesnt exist in either of the two original tables.
@romeokamil2 жыл бұрын
hi did select on top 7 from source table, 1524 was not in top 7 but matched the values for the merge.
@TheSomestuffs3 жыл бұрын
Good...
@FloKluge Жыл бұрын
Cool video, but the merge did not update a rating change from 1 to 2 or from 2 to 1.
@PedramRasti3 жыл бұрын
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
@tihanapolezari76382 жыл бұрын
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.
@harshalpatel5553 жыл бұрын
Hey James How do i get this script to practise
@JamesOliver3 жыл бұрын
Let me check if I can find it
@thedatastoryteller56923 жыл бұрын
Tech people can learn to actually ARTICULATE from you as they need your coaching. I work with tech people and NEVER understand their explantions.