sip con un left join y haciendo un datediff :)
algo asi:
Código SQL:
Ver originalCREATE TABLE #temp
(
id INT IDENTITY(1,1),
dato VARCHAR(20),
fecha datetime
)
INSERT INTO #temp VALUES ('yo',GETDATE())
INSERT INTO #temp VALUES ('tu',dateadd(dd,1,GETDATE()))
INSERT INTO #temp VALUES ('el',dateadd(dd,2,GETDATE()))
INSERT INTO #temp VALUES ('nosotros',dateadd(dd,3,GETDATE()))
INSERT INTO #temp VALUES ('ustedes',dateadd(dd,4,GETDATE()))
INSERT INTO #temp VALUES ('ellos',dateadd(dd,5,GETDATE()))
INSERT INTO #temp VALUES ('aquellos',dateadd(dd,7,GETDATE()))
SELECT t1.id,t1.dato,CASE WHEN isnull(t2.fecha,0)=0 THEN 'No data' ELSE CONVERT(VARCHAR(20),t2.fecha,101) END AS diff FROM #temp AS t1
LEFT JOIN (SELECT * FROM #temp WHERE DATEDIFF(dd,getdate(),fecha)>=1 AND DATEDIFF(dd,getdate(),fecha)<=3) AS t2 ON (t1.id=t2.id)
ya nada mas adecualo a tus necesidades