How To Use T-sql Merge In This Case?

I'm new to T-SQL command MERGE so I found a place in my SQL logic where I can use it and want to test it but can't figure out how exactly should I use it: IF (EXISTS (SELECT 1 FROM

Solution 1:

Did you look in the help? Here's a simple example:

MERGEdbo.commissions_historyAStargetUSING (SELECT @amount, @requestID) ASsource (amount, request)
ON (target.request = source.request)
WHEN MATCHED THEN
    UPDATE SET amount = source.amount
WHENNOT MATCHED THEN
    INSERT (request, amount)
    VALUES (source.request, source.amount);

Solution 2:

I hope it will work

MERGEcommissions_historyAStargetUSING (SELECT request FROM  commissions_history WHERE request = @requestID) ASsource (request)
ON (target.request = source.request)
WHEN MATCHED THEN 
    UPDATE SET amount = @amountWHENNOT MATCHED BY SOURCE    
    INSERT (request, amount)
    VALUES (@requestID,  @amount)