数据横向显示问题?

[lq1013]

表结构如下:
matimebookid int 自增长,
worktime smalldatetime,
nUserID int
数据
1 2006-02-14 07:30:01 1
2 2006-02-14 07:40:01 1
3 2006-02-15 07:30:01 1
4 2006-02-15 07:40:01 1
5 2006-02-14 07:30:01 2
6 2006-02-14 07:40:01 2
7 2006-02-15 07:30:01 2
8 2006-02-15 07:40:01 2
要求显示格式:
1,2006-02-14 07:30:01,2006-02-14 07:40:01
1,2006-02-15 07:30:01,2006-02-15 07:40:01
2,2006-02-14 07:30:01,2006-02-14 07:40:01
2,2006-02-15 07:30:01,2006-02-15 07:40:01

[lq1013]

没有规律,这是一个考勤表

[-狙击手-]

create table tt(id int,d datetime,userid int)
insert tt select 1,'2006-02-14 07:30:01',1 union all
select 2,'2006-02-14 07:40:01',1 union all
select 2,'2006-02-14 07:50:01',1 union all
select 3,'2006-02-15 07:30:01',1 union all
select 4,'2006-02-15 07:40:01',1 union all
select 5,'2006-02-14 07:30:01',2 union all
select 6,'2006-02-14 07:40:01',2 union all
select 7,'2006-02-15 07:30:01',2 union all
select 8,'2006-02-15 07:40:01',2

go
create function get(@d datetime,@userid int)
returns varchar(1000)
begin
declare @s varchar(8000)
set @s = ''
select @s = @s + ',' + convert(varchar(19),d,120) from tt where datediff(d,d,@d) = 0 and userid = @userid
select @s = stuff(@s,1,1,'')
return @s
end
go
select distinct userid,dbo.get(d,userid) as d from tt


drop table tt
drop function get

/*


userid d
----------- ------------------------------------------------------
1 2006-02-14 07:30:01,2006-02-14 07:40:01,2006-02-14 07:50:01
1 2006-02-15 07:30:01,2006-02-15 07:40:01
2 2006-02-14 07:30:01,2006-02-14 07:40:01
2 2006-02-15 07:30:01,2006-02-15 07:40:01

*/

[lq1013]

多谢参与

[-狙击手-]

declare @t table(id int,d datetime,userid int)
insert @t select 1,'2006-02-14 07:30:01',1 union all
select 2,'2006-02-14 07:40:01',1 union all
select 3,'2006-02-15 07:30:01',1 union all
select 4,'2006-02-15 07:40:01',1 union all
select 5,'2006-02-14 07:30:01',2 union all
select 6,'2006-02-14 07:40:01',2 union all
select 7,'2006-02-15 07:30:01',2 union all
select 8,'2006-02-15 07:40:01',2

select * from @t
select distinct userid,min(d),max(d) from @t group by convert(char(8),d),userid
/*


userid
----------- ------------------------------------------------------ ------------------------------------------------------
1 2006-02-14 07:30:01.000 2006-02-14 07:40:01.000
1 2006-02-15 07:30:01.000 2006-02-15 07:40:01.000
2 2006-02-14 07:30:01.000 2006-02-14 07:40:01.000
2 2006-02-15 07:30:01.000 2006-02-15 07:40:01.000

（所影响的行数为 4 行）


*/

[lq1013]

假如一天中有三条记录,我也要显示三条出来啊

[-狙击手-]

假如一天中有三条记录,我也要显示三条出来啊
---
什么意思，发点数据看看

[lq1013]

1,2006-02-14 07:30:01,2006-02-14 07:40:01,2006-02-14 07:50:01
1,2006-02-15 07:30:01,2006-02-15 07:40:01,null
2,2006-02-14 07:30:01,2006-02-14 07:40:01,null
2,2006-02-15 07:30:01,2006-02-15 07:40:01,null

[-狙击手-]

每天的记录数据是未知的？
有规律吗？