declare @Que nvarchar(max),@MonthNm nvarchar(50),@UpdateMonth decimal(18,2) set @MonthNm='July' set @UpdateMonth=1500
set @Que ='update INCENTIVE.dbo.Direct_Summary_Policies set '+@MonthNm+'='+CONVERT(NVARCHAR(10),@UpdateMonth)
set @Que ='UPDATE INCENTIVE.dbo.Direct_Summary_Policies SET ' + @MonthNm + ' = ' + CONVERT(VARCHAR,@UpdateMonth) + ''' Print (@Que)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)