Stroed Procedure Help 1

[TheConeHead]

I know nothing abour stored procudures and need help. I need a stored procedure that will check a date field and if it is 10 minutes old then it will change another fiedl to a certain value. I need it to be managed within SQL (it will not be called externally)

Any help?

 

[WhiteKnight57t]

Is it the query you need?

Update <table> SET <Field> = '<X>'
Where DateDiff(DateAdd(n, 10,<datefield>), getdate()) > = 0
And <Field> <> '<X>'

-- <X> is the value you want to change to


==========================
Date is a way to show you care
Time is a great healer
DateTime is just damn confusing

Tim

 

[TheConeHead]

I need the T-SQL to write the stored procedure and then to know how to call it from within SQL -- so basicaly I need it all -- sorry....

 

[WhiteKnight57t]

BOL is the place to go --
Check it out!

Type in Create procedure

==========================
Date is a way to show you care
Time is a great healer
DateTime is just damn confusing

Tim

 

[TheConeHead]

beauty - I always forget about that...