sql列变行是很多人都没有用到。我现在举一个例子:
declare @str varchar(200)
set @str=''
select @str=@str+'select czy,'
select @str=@str+'sum(case sflb when '收费名称' then ssje else 0 end)'
set @str=@str+'from V2_mz_sfdjmx group by czy'
execute(@str)
select @str
sql列变行是很多人都没有用到。我现在举一个例子:
declare @str varchar(200)
set @str=''
select @str=@str+'select czy,'
select @str=@str+'sum(case sflb when '收费名称' then ssje else 0 end)'
set @str=@str+'from V2_mz_sfdjmx group by czy'
execute(@str)
select @str