Dwain,

trying to reverse eng your super code, is this a place to use Cross Apply ONLY, or could be done with Join.

I can't get second Cross Apply

--CROSS APPLY (SELECT n FROM Tally WHERE n BETWEEN 1 AND period+1) c

inner join #Tally on N between 1 and Period+1

CROSS APPLY (SELECT [month]=DATEPART(month, a.fromDD+n-1),DD=CAST(a.fromDD+n-1 AS DATE)) d

Thank again

M