请教PB里的SQL语句写法
在查询分析器中,执行以下行转列的存储过程,能得出行转列的结果.
CREATE PROCEDURE report_cw AS
begin
declare @s nvarchar(4000)
set @s=''
Select @s=@s+','+quotename([type2])+'=max(case when [type2]='+quotename([type2],'''')+' then [total] else 0 end)' from TB1 group by [type2]
set @s='select [name],sum(total) as total'+@s+' from TB1 group by name order by name'
exec(@s)
end
GO
@s的值如下:(其中长度有1000多字符左右)
select [name],sum(total) as total,[差旅费]=max(case when [type2]='差旅费' then [total] else 0 end),[接待费]=max(case when [type2]='接待费' then [total] else 0 end),[礼品]=max(case when [type2]='礼品' then [total] else 0 end),[设计费]=max(case when [type2]='设计费' then [total] else 0 end),[外包费]=max(case when [type2]='外包费' then [total] else 0 end),[赠送]=max(case when [type2]='赠送' then [total] else 0 end),[准备金]=max(case when [type2]='准备金' then [total] else 0 end) ...... from TB1 group by name order by name
如果我把上面的存储过程,在PB里写,不用调用存储过程(试了多次得不了@S的值!)
想得到上面的@s的字符串值,如何写?