How do you handle the fact that Saturday and Sunday do not have a place in the Staff table?

Another way to get your code:SELECT 'SELECT DISTINCT ' + AC.[name] + ' AS Column_Name FROM ' + T.[name]

FROM sys.tables AS T

INNER JOIN sys.all_columns AC ON T.[object_id] =...

Where does the zero come from? The way the test data is defined it seams to be correct. If the value is only to be used once (the...

Thanks for the tip. The code was developed in SQL2000 and never updated properly.

I do a kill on current users (there should be none) just before a full backup. I create a temp table of users with:

SELECT

P.spid...

Is there no way to tell when a record was added?

Are you trying to keep two tables in sync? If so look into replication.

If the databases are linked, and the data is NOT in the target then just use an insert:INSERT INTO QA.dbo.table1

SELECT * FROM PROD.dbo.table1 WHERE CDate BETWEEN '1/10/2012 6:00' AND...