Update Date/Time Field

[angiem]

I need to update a date/time field with a number of hours held in another table(appconfig.apptime) I have tried this code but it errors about the other table.

UPDATE customer
SET appdate = dateadd(h,appconfig.apptime,getdate())


Thanks

Angie

 

[gmmastros]

You want to update all the records in this table? The simplest way would be to grab the apptime in to a variable and then use the variable to update the other table. Like this:

Declare @AppTime Integer

Select @AppTime = AppConfig.AppTime
From   AppConfig

UPDATE customer 
SET appdate = dateadd(h,[!]@AppTime[/!],getdate())

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom