Therein lies my problem. Nothing like posting a question before doing your homework. Sorry for the trouble.

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May...

Here are a few versions of the query I've already attempted. I'll only be posting the first few lines as it appears that's the section in question.

use cu_hds

;With...

Thank you for the help. lmu92 your suggestion worked.

The final stage is to create this as a SQL Agent job.

I now have the following query as the...

Hmm, I am still having issues when I try to reference the table the values are in. Here is the query/errors:

IF (ProcessID = 2 and EndTime > CONVERT(varchar(10),GETDATE(),101))

and Result...