Select de meses con valor ?

[pepelucho]

TENGO LA SOLUCION:

DECLARE @INTE INT
DECLARE @VAR VARCHAR(8000)
DECLARE @DATO INT
SET @DATO = 0
SET @VAR =''
SET @INTE=11
WHILE @INTE>=0
BEGIN
SET @DATO = @INTE
SET @VAR = 'SELECT ''' +
REPLICATE('0',2 -LEN(MONTH(DATEADD(MONTH,-@INTE,GETDATE())))) +
CAST(month(DATEADD(MONTH,-@INTE,GETDATE())) AS VARCHAR(4)) +
CAST(YEAR(DATEADD(MONTH,-@INTE,GETDATE())) AS VARCHAR(4)) + ''' [ITEM],''' +
DATENAME(M,DATEADD(MONTH,-@INTE,GETDATE())) + ' ' +
CAST(YEAR(DATEADD(MONTH,-@INTE,GETDATE())) AS VARCHAR(4))+ '''[PERIODO] ' [DATA] UNION ' + @VAR
SET @INTE=@INTE-1

END
SET @VAR= LEFT(@VAR,LEN(@VAR)-5) + ' ORDER BY 3 ASC'

EXEC (@VAR)