如何找到连续日期的记录？

[issacp]

CREATE TABLE TT (ID VARCHAR(10),SDATE VARCHAR(20))
GO
INSERT INTO TT VALUES('1','2009-07-21')
INSERT INTO TT VALUES('1','2009-07-23')
INSERT INTO TT VALUES('1','2009-07-24')
INSERT INTO TT VALUES('1','2009-07-25')
INSERT INTO TT VALUES('1','2009-07-26')
INSERT INTO TT VALUES('1','2009-07-27')
INSERT INTO TT VALUES('1','2009-07-28')
INSERT INTO TT VALUES('1','2009-07-11')
INSERT INTO TT VALUES('1','2009-07-13')
INSERT INTO TT VALUES('1','2009-07-17')
INSERT INTO TT VALUES('1','2009-07-22')
GO

[csdyyr]

SELECT *
FROM TT AS T
WHERE EXISTS(SELECT * FROM TT WHERE ABS(DATEDIFF(DAY,SDATE,T.SDATE))=1)
ORDER BY SDATE

[issacp]

谢谢，楼上的兄台,CSDN就是高手多，一个字快，呵呵