You could either store the previous version of the table in a different table on the database and then update the Y/N flag on your new version.

Or you could import...

Thanks for your help guys.

s

Actually, I seem to have solcved this by removing the With NORECOVERY Option from my restore

Not my finest bit of code but...

set nocount on

declare @startdate datetime

declare @table table (DW int)

set @startdate = '1 Jan 2006'

while @startdate < getdate()

begin

        insert into @table (DW)

        values (datepart(dw,@startdate))

       ...

I would have thought it would something like

DELETE from table2 where description NOT IN (select description from table1) AND referenceID not in (select  referenceID from table1)

S

How about

select e.<FieldList> from Employees e

where e.EmployeeId not in

(select EmployeeId from EmployeeTraining where CourseRefNo = <CourseId&gt

that should do the trick.

S

Fantastic, this is just what  was hoping to hear.

Thanks very much

S

There are several ways to store the output in excel.

The two easiest are

1. In query Analyzer set your Output to File and your ouput format to CSV (Tools->Options->Results will create...

I'm sure you've already thought of this, but if the reference to the Access DB refers to a drive letter, it may be a different letter for the SQL Agent -...

Thanks - that is a useful tip on the error log.  I will be making sure we do that in future.

Thanks for all your suggestions, I will continue to monitor the...