April 14, 2011

Insert into another table if not exists SQL Server

INSERT INTO [ServerName\SQLEXPRESS].HULOutbound.dbo.CallHistory
(HID,CID,ConnectedStatus,CDateTime,EnterBy,Attempt,Remarks)
SELECT HID,CID,ConnectedStatus,CDateTime,EnterBy,Attempt,Remarks FROM CallHistory T7
WHERE
DAY(@CDATE) = DAY(CDateTime)
AND
MONTH(@CDATE) = MONTH(CDateTime)
AND
YEAR(@CDATE) = YEAR(CDateTime)
AND
NOT EXISTS
(SELECT 1 FROM [ServerName\SQLEXPRESS].HULOutbound.dbo.CallHistory T19 WHERE T7.HID = T19.HID AND T7.CDateTime = T19.CDateTime)

No comments:

Post a Comment