-- create a test table and populate
CREATE TABLE #tmp(id INT, Dt DATETIME);
INSERT INTO #tmp VALUES (1,'20120101');
INSERT INTO #tmp VALUES (2,'20120107');
INSERT INTO #tmp VALUES (3,'20120112');
INSERT INTO #tmp VALUES (4,'20120122');

-- select id, date and date from the next row.
SELECT
	a.id,
	a.Dt AS DateFromThisRow,
	b.Dt AS DateFromNextRow
FROM
	#tmp a
	LEFT JOIN #tmp b ON a.id+1 = b.id;

-- cleanup
DROP TABLE #tmp;

-- create a test table and populate
CREATE TABLE #tmp(id VARCHAR(5), Dt DATETIME);
INSERT INTO #tmp VALUES ('sdfew','20120101');
INSERT INTO #tmp VALUES ('sdfew','20120107');
INSERT INTO #tmp VALUES ('sdfew','20120112');
INSERT INTO #tmp VALUES ('sdfew','20120122');

-- select id, date and date from the next row.

with cte (id,dt,rn)
as
(SELECT
	id
	,Dt AS DateFromThisRow	
	,ROW_NUMBER() OVER(order by id) as RN
FROM
	#tmp 
)

SELECT
	a.id,
	a.Dt AS DateFromThisRow,
	b.Dt AS DateFromNextRow
FROM
	cte a
LEFT JOIN 
	cte b ON a.rn+1 = b.rn;

drop table #tmp