Thursday, October 29, 2009

Dynamic Update statement

declare @sqlUpt varchar(max)

select @sqlUpt= ('update tbl_TEMP_pp2 set '+ @RepMonth +'=40 WHERE [Rep CTR Number]=''' + @RepCTRNumber + '''')

exec(@sqlUpt)

No comments:

Post a Comment