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

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

Thank you, PERFECT EXPLANATION !

Simple, clear explanation. Thanks!

Wow, this is very neat. TY for these.

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

Very helpful video, thank you for the explanation!

wow what a cool tutorial, loved it!

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

@JamesOliver

2 жыл бұрын

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

@briancanfield2968

Жыл бұрын

Agreed

Very well explained!

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

Excellent video! ❤

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

Amazing video ,ty 😎

Thank you, very nicely explained.

thanks for your great teaching

Awesome video thanks

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

Good job!

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 liked your video, ty

Excellent tutorial

@JamesOliver

3 жыл бұрын

Much appreciated. :)

Nice explanation James

@JamesOliver

2 жыл бұрын

Appreciate it very much. :)

Awesome!! thanks

thank you angel

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.

wow, they were very quick 10 minutes :)

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

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

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#?

Do you have same in oracle?

Good...

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

@JamesOliver

3 жыл бұрын

MicroStrategy video coming Monday

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

2 жыл бұрын

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.

How to merge two stored procedures in mysql.

Hey I am facing issues in merge. Getting an error saying "Merge is not valid at this position"....

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

2 жыл бұрын

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

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

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

Hey James How do i get this script to practise

@JamesOliver

3 жыл бұрын

Let me check if I can find it

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