cursor

 

USe databasename

GO
DECLARE @t NVARCHAR(100)
declare @d DATETIME
declare @n NVARCHAR(100)
DECLARE cur cursor FOR SELECT t.terminalid,t.OutFactoryDate FROM hyd2.terminalinfo t

OPEN  cur
fetch next from cur into @t,@d
UPDATE hyd2.vclinfo SET
hyd2.vclinfo.gpsserviceendtime=dateadd(y,2,@d)
WHERE hyd2.vclinfo.relativeterminalid=@t
CLOSE CUR
DEALLOCATE CUR