This top one works - THANK YOU!

DECLARE @yesterday DATETIME

SET @yesterday = DATEADD(hh,15,DATEADD(dd,DATEDIFF(dd,0,GETDATE()-1),0))

SELECT @yesterday

this one gives me an error: That says DATE is invalid.. not sure if I was suppose to...

BTW, Thank you for responding!

I should have said that I was pretty new to developing, so I kind of understand your terminology, but could you give me an example.

Is there a better way to write the select statement to be able to validate the update?

to Wayne:

Basically, your change worked as long as I put in a few column names, but when i just ran your query, I got this message:

Msg 421, Level 16, State...

To Wayne:

Is my update statement written correctly?

I am not sure about what you said.... The table I am updating has many more rows than the tables I am not updating..

I found another way to do this.

1. Create a sql server agent job

2. Put an email message to yourself or your dba group in step...