if EXISTS (
select * from dbo.sysobjects
where id = object_id(N'[dbo].[CheckTime]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1
)
drop table [dbo].[CheckTime]
GO
CREATE TABLE [dbo].[CheckTime] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Dates] [datetime] NULL
) ON [PRIMARY]
GO
SELECT DISTINCT Name
FROM CheckTime as x
WHERE
DATEDIFF(DAY,'2001-1-1',Dates) >= 0 and DATEDIFF(DAY,'2004-1-31',Dates) <= 0
AND
(SELECT COUNT(DISTINCT Dates) FROM CheckTime
WHERE dates BETWEEN x.dates AND DATEADD(DAY, 6, x.dates)
and Name=x.Name)>=7
(本文章从CSDN上摘录)