April 14, 2011

Use EXCEPT statement in SQL Server

INSERT INTO BranchMaster
(Branch,FranchiseeName)
SELECT DISTINCT BranchName,FranchiseeName FROM ComplaintDetails
WHERE
UploadNumber = @UNO
EXCEPT
SELECT Branch,FranchiseeName From BranchMaster

No comments:

Post a Comment