请大家帮我看看这是行列转置在写条件的时候有什么问题
declare @s nvarchar(4000)
set @s='' Select @s=@s+','+quotename([use_departments])+
'=max(case when [use_departments]='+quotename([use_departments],'''')
+' then [account] else 0 end)' from v_cview where 1=1 and convert(char(8),consuming_date,112)
like '2010%' group by [use_departments] exec('select [consuming_name]'
+@s+' from v_cview group by [consuming_name]')在模糊查询like '2010%'的时候还有不符合条件的数据,哪写的不对
谢谢大家
declare @s nvarchar(4000)
set @s='' Select @s=@s+','+quotename([use_departments])+
'=max(case when [use_departments]='+quotename([use_departments],'''')
+' then [account] else 0 end)' from v_cview where 1=1 and convert(char(8),consuming_date,112)
like '2010%' group by [use_departments] exec('select [consuming_name]'
+@s+' from v_cview group by [consuming_name]')在模糊查询like '2010%'的时候还有不符合条件的数据,哪写的不对
谢谢大家
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货