The Tech Pursuit
The Dev Shelf
Pages
Home
Interview Questions
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