我写了一个游标,
declare m CURSOR FOR
select a.emplid,a.classid, a.workdate from RS_KQ_EmplSys a
left join RS_DA_empl b on a.emplid=b.emplid
left join RS_KQ_Work_System c on c.id=a.classid
执行:
declare @s varchar(8000)
set @s=''
select @s=@s+',['+rtrim(a)+']=max(case a when '''+rtrim(a)+''' then b else '''' end )'
from t2 group by a
set @s=stuff(@s,1,1,'')
exec('select '+@s+' from t2 ')
create table 工资条(员工 ,基本工资 ,养老保险 ,加班)
declare all_record scroll cursor for select * from 工资表
open all_record
fetch next from all_record into @员工,@工资项,@工资
while @@fetch_status=0
if @工资项='基本工资'
insert into 工资条(员工 ,基本工资 ,养老保险 ,加班) values(@员工,@工资,0,0)
if @工资项='养老保险'
insert into 工资条(员工 ,基本工资 ,养老保险 ,加班) values(@员工,0,@工资,0)
if @工资项='加班'
insert into 工资条(员工 ,基本工资 ,养老保险 ,加班) values(@员工,0,0,@工资)