Hi

The tables first need to be joined. The rows to be excluded can be filtered using a where clause or by specifying the criteria in the join itself.

from table2

join table1...

Hi

Why is there an extra 7 in the code?

I would use the ffg script to get midnight a week ago:

select dateAdd(dd,datediff(dd,0,getdate()-7),0)

but if I wanted to keep everything from this...

How is it that your application or SQL knows who is running the query? Are you checking SUSER_NAME(), USER_NAME() as explained above?

Hi

Just wondering if there is a way to link the 2 tables? Is EmployeeNumber the primary key? I'm sure its a fairly easy update script if the 2 tables were...

The nested example is a good example as an explanation.

In the real world we would change the ORDER BY clause for one of the select statements. For instance, when...