SQLTeam.com | Weblogs | Forums

Need to insert and update large amount of data


#1

Hi,
I need to inseet/update data froma staging table to another sql table. Can someone help please?

TIA
Isha


#2

What is the problem? Do you need assistance on creating the code or optimizing the code you have?


#3

This sample code may be helpful to you.

MERGE 
    INTO Persons AS TARGET
    USING Persons_Staging AS SOURCE
    ON TARGET.ID = SOURCE.ID
    --WHEN MATCHED
    --    THEN UPDATE???
    WHEN NOT MATCHED BY TARGET
        THEN INSERT (Id , LastName , FirstName, HouseNumber)
    VALUES (SOURCE.Id , SOURCE.LastName , SOURCE.FirstName, SOURCE.HouseNumber)
    -- WHEN NOT MATCHED BY SOURCE
    --    THEN DELETE???
;

Do you want to know the best practices to insert and update a large amount of data. You should go this blog here you may find the help. http://sqlblog.net/2014/05/01/insert-and-update-records-with-a-ssis-etl-package/