考勤表的横向表现,列显示为8位员工

时间:2013-01-09 06:07:07
【文件属性】:

文件名称:考勤表的横向表现,列显示为8位员工

文件大小:2KB

文件格式:RAR

更新时间:2013-01-09 06:07:07

考勤表SQL

--测试数据 create table tb_kq( banzu varchar(20), chuqinqk varchar(20), name varchar(20), primary key(banzu,chuqinqk,name) ); insert into tb_kq(banzu,chuqinqk,name) select '班组1','出勤','张1' union select '班组1','出勤','张2' union select '班组1','出勤','张3' union select '班组1','出勤','赵12' union select '班组1','出勤','钱11' union select '班组1','出勤','刘1' union select '班组1','出勤','刘2' union select '班组1','出勤','赵2' union select '班组1','出勤','赵3' union select '班组1','病假','张8' union select '班组1','病假','张11' union select '班组1','病假','张9' union select '班组1','病假','张90' union select '班组1','矿工','王1' union select '班组1','矿工','王3' union select '班组1','矿工','王4' union select '班组2','出勤','刘1' union select '班组2','出勤','刘2' union select '班组2','出勤','刘21'


【文件预览】:
kq.txt
d_kq.srd

网友评论