autoexcrement (6/6/2014)
The end goal is that Live should have one record for every unique combination of the 8 "tracked" columns.
.
maybe an idea?
INSERT INTO [dbo].[live]
([col1]
,[col2]
,[col3]
,[col4]
,[col5]
,[col6]
,[col7]
,[col8])
(
SELECT [col1]
,[col2]
,[col3]
,[col4]
,[col5]
,[col6]
,[col7]
,[col8]
FROM scratch
EXCEPT
SELECT [col1]
,[col2]
,[col3]
,[col4]
,[col5]
,[col6]
,[col7]
,[col8]
FROM live
)
GO
with reference to NULLs
http://msdn.microsoft.com/en-gb/library/ms188055(v=sql.90).aspx
When you compare rows for determining distinct values, two NULL values are considered equal.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day