How to print Months without using Loop

Posted by PandianS under Sql Server category on 2/18/2011 | Points: 40 | Views : 3135

Post Code |

Search Codes |

Code Home

;WITH CTEs
AS
(
SELECT 0 AS [Month]
UNION ALL
SELECT [Month] +1 FROM CTEs WHERE [Month]<11
)

SELECT [Month]+1 [Month], DATENAME(M,DATEADD(M,[Month],'2011-01-01')) [Month Name] FROM CTEs
GO

Alert Moderator

Bookmark It

Comments or Responses

Posted by: T.saravanan on: 2/21/2011 Level:Silver | Status: [Member] [MVP] | Points: 10

Hi PandianS,

Thanks for your sharing.
Its really nice and continue your great job.

Latest Code Snipptes

writing Custom pagination html code in python and django
Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
More ...