Hello,

I think you need to do this:

DECLARE @Query VARCHAR(MAX)

select

@Query = COALesCE( @Query + CHAR(13) , ' ' ) +

'update fl set radicaltipoemp='+convert(varchar,'1')+' from fl where fl.flstamp='''+fl.flstamp+''''

from fl (nolock)

where...