DECLARE @Source table (Column1 int, Column2 varchar(50))
DECLARE @Dest table (Column1 int, Column2 varchar(50))

INSERT INTO @Source VALUES(1, 'Tara')
INSERT INTO @Source VALUES(2, 'Mike')
INSERT INTO @Source VALUES(3, 'Alex')
INSERT INTO @Source VALUES(4, 'Rebecca')
INSERT INTO @Source VALUES(5, 'Zach')

INSERT INTO @Dest VALUES(1, 'Tara')
INSERT INTO @Dest VALUES(2, 'Mike')

SELECT * FROM @Source
SELECT * FROM @Dest

INSERT INTO @Dest (Column1, Column2)
SELECT Column1, Column2
FROM @Source
WHERE Column1 NOT IN (SELECT Column1 FROM @Dest)

SELECT * FROM @Dest

quote:

---

Originally posted by Kevin Driscoll

First timer here..
Was wondering if anyone could help me with a problem.
I have a table of "Historical" general ledger records 3.5 million records.
I have another table that pulls this months current fiscal period records.
I want to be able to automate the inclusion of this months records into the historic table.
This data is pulled nightly so the records may already be in the historical table.

Would like to use a DTS package.
Any ideas?

---