sql auto generate date function starting month to end month

create function fnListMonths @date1 date,@date2 date Return table as Return create Table #tempTable (mnth varchar(10)) while @date1<@date2 begin insert into #tempTable select DATENAME(month,@date1) set @date1 = DATEADD(MONTH,1,@date1) end select * from #tempTable; drop table #tempTable; end Select dbo.fnListMonths(date1,date2)