set @Sql=' select '+ (@col)+' FROM [INCENTIVE].[dbo].[Direct_Summary_Policies] where FinancialYear=''2013-2014'' and EmpCode=''E00532'' ' set @In= (exec (@Sql)
CREATE TABLE #TEST ( TEST Decimal(18,0) ) DECLARE @Sql nVARCHAR(500) Declare @Col NVARCHAR(50) SET @Col = 'TEST' SET @Sql = ' DECLARE @Deci Decimal(18,0) SELECT @Deci = '+@Col +' From #test SELECT @Deci ' Exec (@sql)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)