Let me create a query that shows the present month in text form and so the relaxation of the season printed around the following rows until all several weeks for that year happen to be printed.

This really is somewhat difficult to explain so I have made the next example. I understand the next code is absurd but this is actually the best way I understand to get this done with my current level of skill. Ideally I'd like several weeks to become converted from printing an integer to print the smoothness worth of the month (so 1 could be The month of january). I understand I possibly could do that having a situation/when but I am sure there's an easy method which i weren't uncovered to yet.

declare @currentmonth as int = datepart(month, getdate())
select
    @currentmonth
union
select
    @currentmonth +1
union
select
    @currentmonth +2
union
select
    @currentmonth +3
union
select
    @currentmonth +4
union
select
    @currentmonth +5
union
select
    @currentmonth +6
union
select
    @currentmonth +7
union
select
    @currentmonth +8
union
select
    @currentmonth +9
union
select
    @currentmonth +10
union
select
    @currentmonth +11

In SQL Server 2008+ this can be used

SELECT v.i
FROM (values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12)) v(i)
WHERE v.i>=MONTH(GETDATE())

An opportunity to use common table expression (SQL Server 2005+):

declare @adate datetime
set @adate = '2011-07-31'

;with clndr(m) as (
    select @adate
    union all
    select dateadd(month, 1, m)
    from clndr
    where datepart(year, dateadd(month, 1, m)) = datepart(year, @adate)
)
select datename(month, m)
from clndr

With Common table expression it is simple to write the code

    DECLARE @currentmonth INT
    SET @currentmonth=datepart(month, getdate())
    ;WITH CTE AS
    (SELECT @currentmonth AS currentmonth 
       UNION ALL 
     SELECT currentmonth +1 FROM CTE WHERE currentmonth <10
    )

    SELECT * FROM CTE