If you use MS SQL Server, i recommend you to use
CTE[
^]:
;WITH MyColumns
AS
(
SELECT GETDATE() AS CurrMonth, '1200/' AS FirstPart , 12 AS SecondPart
UNION ALL
SELECT DATEADD(mm,1, CurrMonth), FirstPart, SecondPart -1 AS SecondPart
FROM MyColumns
WHERE SecondPart>1
)
SELECT DATENAME(mm, CurrMonth) AS Col1, FirstPart + CASE WHEN LEN(SecondPart)=2 THEN CAST(SecondPart AS NVARCHAR(2)) ELSE '0' + CAST(SecondPart AS NVARCHAR(2)) END AS Col2
FROM MyCOlumns
Result:
April 1200/12
May 1200/11
June 1200/10
July 1200/09
August 1200/08
September 1200/07
October 1200/06
November 1200/05
December 1200/04
January 1200/03
February 1200/02
March 1200/01