• This might be what you are looking for:

    SELECT CONVERT(VARCHAR(7), GETDATE(), 111) AS [YYYY/MM]

    Result:

    2013/09

    ]

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]