Diferencias entre dos fechas dif columna

[Libras]

utilizando DATEDIFF, y claro usando subqueries ;)

Código SQL:

CREATE TABLE #temp
(
dato VARCHAR(20),
dato2 datetime,
ROW INT
)
INSERT INTO #temp VALUES ('MOR-BK005','2011-08-26 00:00:00.000',1)
INSERT INTO #temp VALUES ('MOR-BK005','2012-02-14 00:00:00.000' ,2)
INSERT INTO #temp VALUES ('MOR-BK005','2012-06-28 00:00:00.000' ,3)
INSERT INTO #temp VALUES ('MOR-BK005','2012-10-11 00:00:00.000' ,4)
INSERT INTO #temp VALUES ('MOR-BK005','2013-01-15 00:00:00.000' ,5)
INSERT INTO #temp VALUES ('MOR-BK005','2013-05-13 00:00:00.000' ,6)
INSERT INTO #temp VALUES ('MOR-BK005','2013-08-10 00:00:00.000',7)
 
 
SELECT t1.dato,t1.dato2,t2.dato2,datediff(mm,t1.dato2,t2.dato2) AS dif_mes FROM #temp AS t1
LEFT JOIN #temp AS t2 ON (t2.ROW=t1.ROW+1)
WHERE t2.dato IS NOT NULL
 

saludos!