• declare @year char(4),@month char(2)

    set @year=convert(char(4),getdate(),120)

    set @month=right(convert(char(7),getdate(),120),2)

    select @month + '-' + @year

     

    -Krishnan