Codigo SQL server
Código SQL:
Ver originalCREATE TABLE #temp
(
id INT,
cliente VARCHAR(10),
fecha datetime
)
INSERT INTO #temp VALUES (1 ,'v1','2015-05-20')
INSERT INTO #temp VALUES (2 ,'v1','2015-05-20')
INSERT INTO #temp VALUES (3 ,'v1','2015-05-01')
INSERT INTO #temp VALUES (4 ,'v1','2015-03-05')
INSERT INTO #temp VALUES (5 ,'v2','2015-02-02')
INSERT INTO #temp VALUES (6 ,'v3','2015-01-30')
INSERT INTO #temp VALUES (7 ,'v1','2015-01-01')
SELECT calculo, id,cliente FROM(
SELECT CASE WHEN t1.cliente<>t2.cliente THEN t2.fecha END AS calculo, t1.id AS id,t1.cliente AS cliente FROM #temp AS t1
INNER JOIN #temp AS t2 ON (t1.id+1=t2.id)
) AS t3 WHERE calculo IS NOT NULL
Resultado:
calculo id cliente
2015-02-02 00:00:00.000 4 v1
2015-01-30 00:00:00.000 5 v2
2015-01-01 00:00:00.000 6 v3