rango de fechas de un campo a otro interauto

sqlRangeTOdaTETODAte.sql

/*
FCECP -> FCADUANA   as  ecp-aduana
FCADUANA ->  FCARRIBADO  as adu-arribado
FCADUANA -> FCPAGPED as aduana-pagped
FCADUANA -> FCSOL as aduana-sol
FCARRIBADO -> FCGONDOLA as arribado-gondola 
FCPAGPED -> FCGONDOLA as pagped-gondola
FCSOL -> FCGONDOLA as sol-gondola
FCARRIBADO -> FCPENTACO as arribado-pentaco
FCPAGPED -> FCPENTACO as pagped-pentaco
FCSOL -> FCPENTACO as sol-pentaco
FCGONDOLA -> SEMANA as gondola-semana
FCPENTACO -> SEMANA as  pentaco-semana
*/



Select FCECP, 
	DATEDIFF(DAY,FCECP, FCADUANA) AS ecpAduana,
	DATEDIFF(DAY,FCADUANA, FCARRIBADO) AS aduanaArribado,
	DATEDIFF(DAY,FCADUANA, FCPAGPED) AS aduanaPagped,
	DATEDIFF(DAY,FCADUANA, FCSOL) AS aduanaSol,
	DATEDIFF(DAY,FCARRIBADO, FCGONDOLA) AS arribadoGondola ,
	DATEDIFF(DAY,FCPAGPED, FCGONDOLA) AS pagpedGondola,
	DATEDIFF(DAY,FCSOL, FCGONDOLA) AS solGondola,
	DATEDIFF(DAY,FCARRIBADO, FCPENTACO) AS arribadoPentaco,
	DATEDIFF(DAY,FCPAGPED, FCPENTACO) AS pagpedPentaco,
	DATEDIFF(DAY,FCSOL, FCPENTACO) AS solPentaco,
	DATEDIFF(DAY,FCGONDOLA, FCSEMANA) AS gondolaSemana,
	DATEDIFF(DAY,FCPENTACO, FCSEMANA) AS pentacoSemana,
	DATEDIFF(DAY,FCECP, FCADUANA) AS InicioFin,
	 * from app_contenedor where REFERENCIA='GUSE5649609'