and sorry for the format : it's my first time asking questions in a forum!:-)

some details:

d_an = first year with a specific medical condition

before this date : d_YEAR=0

after this date:...

Hello,

in fact I did something similar:-)

'd_1998'=

case when diab_d1=1998 then 1

else 0

end,

but it is with the next step that I have some pb:

DECLARE @sql VARCHAR(500)

DECLARE @Annee INT

SET @Annee=1998

WHILE @Annee<=2011

BEGIN

SET @sql='UPDATE diab_an_actif2...