动态SQL语名,如何获取 结果集合
declare @Account varchar(30) --科目编码
declare @column varchar(3000)
declare @sql varchar(4000)
set @sql = ''
set @column = ''
--赋值
SELECT @column= @column+','+'max(case when adjustType='''+adjustbh+''' then adjustvalue end) as '+columnfield
FROM srv_Info.WF_Info.dbo.BD_AccountAdjust a join srv_Info.WF_Info.dbo.BD_DB_AdjustInfo b on a.adjustid= b.adjustbh
where a.accountid = @Account
set @sql = 'select pzbh,zibh,account '+ @column+ ' from dbo.CW_PD_PZSU WHERE ACCOUNT = '+@Account+' group by pzbh,zibh,account'
print @sql
exec (@sql)
----如题,我的列是动态列,如何根据动态SQL语名,把执行的结果给取出来放到动态的表中,因为列是动态的所以获取后的数据集合也是动的,请教高手