27,580
社区成员
发帖
与我相关
我的任务
分享
-- 1.
USE DB
GO
CREATE TABLE [刷卡记录]
(
[ID] INT IDENTITY(1,1) PRIMARY KEY
,[学号] NVARCHAR(100)
,[日期] DATE
,[刷卡时间] VARCHAR(100)
,[标记] BIT
)
GO
INSERT INTO [刷卡记录] SELECT '2011','2011-01-01','8:00',0
UNION ALL SELECT '2011','2011-01-01','11:00',1
UNION ALL SELECT '2012','2011-01-01','8:00',0
UNION ALL SELECT '2012','2011-01-01','11:00',1
UNION ALLSELECT '2012','2011-01-01','11:10',0
UNION ALL SELECT '2012','2011-01-01','11:50',1
GO
SELECT * FROM [刷卡记录]
select 学号,日期,(select [刷卡时间]+',' from [刷卡记录] x where x.学号=y.学号 for xml path('')) from [刷卡记录] y group by 学号,日期