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
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 ruclips.net/video/wK93ZE78cew/видео.html
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.
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?
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.
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.
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
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
Nice tutorial about "SQL Merge". Thank you for your sharing :)
Thank you Marc for appreciating.
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
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
ruclips.net/video/wK93ZE78cew/видео.html
Thanks for your time I am watching from #Adelaide #Australia
Thanks for your time Sir.
Very Helpful vlog ... thanks sir 🙏
You are most welcome.
Thank you so much sir for vedios and SQL script🙏
Thank you Vicky.
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.
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.
@@learnssis Highly appreciated and such tutorial for all or some of those solutions you mentioned are NEEDED.
Can you explain implement SCD type2 concept using merge query.
Hi Anil. We should use merge statments in excute SQL task in SSIS
yes we can use it in Execute sql task.
very nicely explained, Thanks
Thank you Shahin Alam for appreciating this.
can you please also do SCD2 implementation please which works for all scenarios
I have done SCD type 2 in SSIS.
ruclips.net/video/7uj463csru0/видео.html
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?
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 presentation. and well explained
Thank you Eric.
We can do scd type 2 with merge statement in sql server. But in oracle, how to do insert after update when matched
Sorry I have not worked with Oracle, thus not sure about that. Can you try chatgpt and see if it gives any useful information ?
@@learnssis Google replaced with ChatGPT :)
What is difference between merge statment and temporal table
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.
@@learnssis ok thank you sir
@@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
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
Thanks