declare @start DATE = '2012-04-01'
declare @end DATE = '2012-08-03'
;with months (date)
AS
(
SELECT @start
UNION ALL
SELECT DATEADD(month,1,date)
from months
where DATEADD(month,1,date)<=@end
)
select Datename(month,date) from months
Hope this will help you .
ROHIT KUMAR SRIVASTAVA
declare @end DATE = '2012-08-03'
;with months (date)
AS
(
SELECT @start
UNION ALL
SELECT DATEADD(month,1,date)
from months
where DATEADD(month,1,date)<=@end
)
select Datename(month,date) from months
Hope this will help you .
ROHIT KUMAR SRIVASTAVA
nice
ReplyDeleteGuys, do you know the game Guild Wars 2? It is a new MMORPG released in 2012. If you like to play games, then you should have a try of GW2. http://www.guildwars2gear.com is good site to dealing gw2 gold at low price and fast delivery speed.
ReplyDelete