1 of 2

Declare @i INT; SELECT @i = 0; CREATE table #temp( numbers int not null); while @i<10 BEGIN insert into #temp values(@i) SELECT @i = @i+1; END SELECT Product, Price, DATEADD(MM,a.numbers,DATEADD(m, DATEDIFF(m, 0,initialDate), 0)) FROM #ProdDate, #temp a where a.numbers <= DATEDIFF(mm,initialDate,finalDate) drop table #temp;