Very Helpful vlog ... thanks sir 🙏

@learnssis

14 күн бұрын

You are most welcome.

Thank you so much sir for vedios and SQL script🙏

@learnssis

3 ай бұрын

Thank you Vicky.

Nice tutorial about "SQL Merge". Thank you for your sharing :)

@learnssis

10 ай бұрын

Thank you Marc for appreciating.

very nicely explained, Thanks

@learnssis

9 ай бұрын

Thank you Shahin Alam for appreciating this.

great presentation. and well explained

@learnssis

10 ай бұрын

Thank you Eric.

Can you explain implement SCD type2 concept using merge query.

Great explanation thank you so much for hardwork.. I watching your videos getting confidence.. one question I have how to send email for more than one person by using script task.. Thanks in advance

@learnssis

10 ай бұрын

Hi, at the moment I don't have a video on sending email to multiple people, you can watch this video where she showed how to send email to multiple people kzread.info/dash/bejne/qX9tlbx-Z5vJldo.html

We can do scd type 2 with merge statement in sql server. But in oracle, how to do insert after update when matched

@learnssis

2 ай бұрын

Sorry I have not worked with Oracle, thus not sure about that. Can you try chatgpt and see if it gives any useful information ?

Hello Sir, So we have to maintain the staging table empty sir or it can hold data also. As Merge can do all three operations right sir? so any reason for making staging table empty each time. And when we load data from source to SSIS for example so when the data is in SSIS until loading to target tables or SQL Server then it can be called as staging sir?

@learnssis

6 ай бұрын

it depends on the kind of requirement in the project. If you just want to insert\update data from staging table to destination table, then you should empty the staging table in the beginning otherwise it will end up having duplicate records. Sorry I did not get your second question.

Great as usual. One request plz if you can do that. How to update data between two servers so that they kept identical? Thank you.

@learnssis

10 ай бұрын

Thank you. if you can create a linked server from one server to another server and then you can use the Merge statement to update data from one server to another server for a sql table. You can also configure replication between 2 servers to keep all tables in Sync or you can create SSIS packages those can sync data from one server to another server.

@abdullahquhtani4247

10 ай бұрын

@@learnssis Highly appreciated and such tutorial for all or some of those solutions you mentioned are NEEDED.

can you please also do SCD2 implementation please which works for all scenarios

@learnssis

6 ай бұрын

I have done SCD type 2 in SSIS. kzread.info/dash/bejne/aamelphsk9bYpZM.html

Hi Anil. We should use merge statments in excute SQL task in SSIS

@learnssis

9 ай бұрын

yes we can use it in Execute sql task.

What is difference between merge statment and temporal table

@learnssis

9 ай бұрын

They both are different. Merge statement is used to insert\update data from one table to another table in sql server, while temporal tables are used to keep historical data of a table.

@arifamakandar2437

9 ай бұрын

@@learnssis ok thank you sir

@learnssis

9 ай бұрын

@@arifamakandar2437You are most welcome Arifa.

Hi in sql i have faced a one question , In a table we have the A,10000 b,5000 c ,2000, again A ,2000 now we need to find the height salary in table and the result should be A, 12000 b,5000 c,2000. can u make a video on this please

@learnssis

9 ай бұрын

This is will be your query create table test(Name varchar(100), Salary int) go insert into test values('A',10000),('B',5000),('C',2000),('A',2000) go select Name, sum(Salary) as TotalSalary from test group by Name

@sreedharagandla

9 ай бұрын

Thanks