The Tech Pursuit
The Dev Shelf
Pages
Home
About Me
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment