求SQL(100分)

表: ID,name,time1,rq 用以下可直接导入SQL2K后调试

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kq]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[kq]
GO

CREATE TABLE [dbo].[kq] (
[id] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[name] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[time1] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[rq] [char] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'上午 09:11:41 ',N'2006-7-10 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'下午 03:13:32',N'2006-7-10 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'上午 08:10:45 ',N'2006-7-11 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'下午 03:10:58',N'2006-7-11 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'上午 07:11:32 ',N'2006-7-12 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'下午 02:43:11',N'2006-7-12 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'上午 07:41:32 ',N'2006-7-13 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'下午 03:23:41',N'2006-7-13 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'上午 08:14:43 ',N'2006-7-14 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'下午 03:16:47',N'2006-7-14 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'上午 08:13:42 ',N'2006-7-15 ')
INSERT INTO [kq] ([name],[time1],[rq]) values (N'张三',N'下午 02:19:47',N'2006-7-16 ')

select * from kq

要求结果:
name 2006-7-10 2006-7-11 2006-7-12 2006-7-13 2006-7-14

张三 上午 09:11:41 上午 08:10:45 上午 07:11:32 上午 07:41:32 上午 08:14:43

张三 下午 03:13:32 下午 03:10:58 下午 02:43:11 下午 03:23:41 下午 03:16:47

我已解决!

呵呵,行列转化的问题,接分来了.

说说思路吧,顺便接分好不好

那个能提供完全能用的PrintAtOnce控件FOR D7 的就把分全部给他

接分来了.