Here is my situation:
CREATE TABLE Test
(Rowid int,
Dt Datetime)
INSERT INTO Test VALUES(1, '01/01/2004')
INSERT INTO Test VALUES(2, '01/15/2004')
INSERT INTO Test VALUES(3, '01/31/2004')
and I want data like:
Rowid start_dt end_dt
1 01/01/2004 01/14/2004
2 01/15/2004...