2 Formatting
source | link

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;

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;

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;

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;
1
source | link

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;