Insert / Union - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Insert / Union

Author

Topic

mike1973
Starting Member

46 Posts

Posted - 2010-12-30 : 04:10:18

hello guys,
i am trying to insert the difference of 2 tables in 1 table
but it's not working any help please?

INSERT INTO TempTable (ToDelete,ToInsert)

SELECT RawData.ID from RawData WHERE RawData.ID NOT IN (
SELECT RawData.ID FROM RawData INNER JOIN
FinalData ON RawData.EmpID = FinalData.EmpID AND RawData.CompanyID = FinalData.CompanyID AND RawData.MonthID = FinalData.MonthID AND
RawData.YearID = FinalData.YearID
WHERE FinalData.IsDeleted='F')

UNION ALL

SELECT FinalData.ID from FinalData WHERE FinalData.ID NOT IN (
SELECT FinalData.ID FROM RawData INNER JOIN
FinalData ON RawData.EmpID = FinalData.EmpID AND RawData.CompanyID = FinalData.CompanyID AND RawData.MonthID = FinalData.MonthID AND
RawData.YearID = FinalData.YearID
WHERE FinalData.IsDeleted='F')

naveengopinathasari
Yak Posting Veteran

60 Posts

Posted - 2010-12-30 : 04:38:39

Do the table contain any PK key??.
Select * FROM RawData R
WHERE EXISTS

(Select * FROM
( Select * From FinalData FF
WHERE EXISTS (
(
Select * FROM
(
(Select * From FinalData)
UNION
(Select * from RawData)
) AS DD
WHERE DD.Col1= FF.Col1 AND DD.Col2 = FF.Col2....
)
AS EE ) AS FFFF
WHERE
FFF.Col1 = FFFF.Col1 AND ....

This should work i hvae just wrote the logic

Lets unLearn

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources