关于交叉表的应用于 考勤系统解决方法

--> 测试数据：[tbl]if object_id('[tbl]') is not null drop table [tbl]create table [tbl]([workid] varchar(5),[recdate] date,[rectime] time)insert into tblselect '02109','2012-3-1','07:36' union allselect '02109','2012-3-1','09:36' union allselect '02109','2012-3-1','17:36' union allselect '02103','2012-3-1','07:36' union allselect '02103','2012-3-1','17:36' union allselect '02109','2012-3-2','07:38' union allselect '02102','2012-3-2','07:36'declare @str varchar(max)set @str=''select @[email protected]+','+QUOTENAME([recdate],'')+'=case when [recdate]='+QUOTENAME([recdate],'''')+' then [rectime] else  null end' from tbl group by [recdate]exec('select [workid][email protected]+'  from tbl')print @str/*workid    2012-03-01    2012-03-0202109    07:36:00.0000000    NULL02109    09:36:00.0000000    NULL02109    17:36:00.0000000    NULL02103    07:36:00.0000000    NULL02103    17:36:00.0000000    NULL02109    NULL    07:38:00.000000002102    NULL    07:36:00.0000000*/
------解决方案--------------------
探讨

感谢楼上 支持 但这个结果并非是我要的结果

就02109 而言 2012-3-1 有3条记录 是需要都显示出来的