22,209
社区成员
发帖
与我相关
我的任务
分享
if OBJECT_ID(N'tempdb.dbo.#code') is not null
drop table #code
go
create table #code
(code nvarchar(10),
field varchar(5))
insert into #code
select '张三','F2' union all
select '张四','F3' union all
select '张五','F4' union all
select '王三','F5' union all
select '王四','F6' union all
select '王五','F7'
if OBJECT_ID(N'tempdb.dbo.#data') is not null
drop table #data
go
create table #data
(F1 nvarchar(10),
F2 decimal(12,4),
F3 decimal(12,4),
F4 decimal(12,4),
F5 decimal(12,4),
F6 decimal(12,4),
F7 decimal(12,4),
F8 decimal(12,4),
F9 decimal(12,4),
F10 decimal(12,4))
insert into #data
select '一次',0.4486,0.4486,0.4486,0.4486,0.4486,0.4486,0.4486,0.4486,0.4486 union all
select '二次',0.6601,0.6601,0.6601,0.6601,0.6601,0.6601,0.6601,0.6601,0.6601 union all
select '三次',0.6621,0.6621,0.6621,0.6621,0.6621,0.6621,0.6621,0.6621,0.6621 union all
select '四次',0.6661,0.6661,0.6661,0.6661,0.6661,0.6661,0.6661,0.6661,0.6661
declare @sql nvarchar(max)
select @sql=ISNULL(@sql+',','')+field+' as '+code
from
(select *
from #code
where code in ('张三','王三')) as A
set @sql='select F1 as F1,'+@sql+' from #data where F1=''三次'''
exec(@sql)