Update a Field Based on DATEDIFF

[dvannoy]

I have a field called STATUS. I'm trying to run a procedure that will update the field STATUS if the below code results are > 8 days

 SELECT        

DATEDIFF(DAY, DATE_FIELD, GETDATE()) AS DAYS_IN_QUE

FROM

TABLE

any help would be appreciated

thanks

 

[bborissov]

UPDATE YourTable SET Status = ????
WHERE DATEDIFF(DAY, DATE_FIELD, GETDATE()) > 8

Is this what you want?

Borislav Borissov
VFP9 SP2, SQL Server