hi friends how to create a auto generate function in date wise ex when i put 10 apr 2015 to 10 dec 2018 is displays date

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)

Answer

sql auto generate date function starting month to end month

Nandha Kumar Nagarajan

510

hi friends

how to create a auto generate function in date wise

when i put 10 apr 2015 to 10 dec 2018

is displays date

Answers (1)

Next Recommended Forum

structure of table

Select comma separated value from multiple column

Leaderboard

View all

George

Mohammad Hasan Hosseini

-160

Sangeetha S

-6

View all

Yesterday's leader

George

USA

4.2m

33.9k

Member of the month

Shafaet Hossain

C#, .NET, ASP.NET, Blazor

Dhaka (Bangladesh)

707

9.6k

1.3k

Upcoming events

View all

What is the Actors: Dapr in Action - Ep. 11
.NET Conference 2025

Suggested for you

View all

Bhawesh Deepak

Vikas Singh

Allani Saikumar

Abdul Basith

Mohamed Shifan

Forum Statistics

Please welcome our newest member naman .
3,078,253 users have contributed to 147,418 threads and 483,404
In the past 24 hours, we have 6 new threads, 27 new posts, and 55 new users.
In last week, the most popular thread is 'ItemId is not able to save into the tblQuantities'.