Riutilizzo record per un'altra select

ALTER PROCEDURE [dbo].[GetRitardi_new]
(
@data1 as Datetime,
@data2 as Datetime
)
AS
BEGIN
SELECT 
alb.codalb,
alb.descrizione,
alb.codcomune,
alb.Tel
FROM dbo.albergo as alb
JOIN
dbo.Apertura_chiusura as Ap
ON alb.Codalb=Ap.codalbergo and alb.CodComune=Ap.codcomune 
Where Ap.Datafineattivita='9999-01-01' and 
(datatemp1='9999-01-01'
or (datatemp1 > @data1 and datatemp2>=@data2)
or (datatemp1<=@data1 and datatemp2<@data2))and
(data1='9999-01-01'
or (data1 > @data1 and data2>=@data2)
or (data1<=@data1 and data2<@data2))
and 
(data3='9999-01-01'
or (data3 > @data1 and data4>=@data2)
or (data3<=@data1 and data4<@data2))
and
(data5='9999-01-01'
or (data5 > @data1 and data6>=@data2)
or (data5<=@data1 and data6<@data2))
and
(data7='9999-01-01'
or (data7 > @data1 and data8>=@data2)
or (data7<=@data1 and data8<@data2))
Order by codalbergo,codcomune
END

;WITH alberghi_step1 AS
(
    -- tua select definita nella stored procedure di cui parlavi prima
)

SELECT
  campi
FROM
  alberghi_step1   A
  JOIN altra_tabella  B ON A.codalb = B.codalb
ORDER BY
  A.codalb

ALTER PROCEDURE [dbo].[GetRitardi_new]
(
@data1 as Datetime,
@data2 as Datetime
)
AS
BEGIN
WITH alberghi_step1 AS
(
SELECT 
alb.codalb,
alb.descrizione,
alb.codcomune,
alb.Tel
FROM dbo.albergo as alb
JOIN
dbo.Apertura_chiusura as Ap
ON alb.Codalb=Ap.codalbergo and alb.CodComune=Ap.codcomune 
Where Ap.Datafineattivita='9999-01-01' and 
(datatemp1='9999-01-01'
or (datatemp1 > @data1 and datatemp2>=@data2)
or (datatemp1<=@data1 and datatemp2<@data2))and
(data1='9999-01-01'
or (data1 > @data1 and data2>=@data2)
or (data1<=@data1 and data2<@data2))
and 
(data3='9999-01-01'
or (data3 > @data1 and data4>=@data2)
or (data3<=@data1 and data4<@data2))
and
(data5='9999-01-01'
or (data5 > @data1 and data6>=@data2)
or (data5<=@data1 and data6<@data2))
and
(data7='9999-01-01'
or (data7 > @data1 and data8>=@data2)
or (data7<=@data1 and data8<@data2))
)
SELECT
A.Codalb,A.Descrizione,A.CodComune,A.Tel 
FROM
  alberghi_step1 A
  Left JOIN dbo.Notifiche N
  ON A.codalb = N.codalbergo and A.Codalb=N.codcomune 
  Where N.datanotifica Not Between @data1 and @data2
  ORDER BY A.codalb,A.CodComune
END