>I have written a query and I am pretty sure that there is a shorter syntax for that.
>
>I want to extract and format and group by the year and the month included in a datetime field.
>
>For now, I have this:
>

SELECT CAST(YEAR(TB.Date) AS CHAR(4)) + '/' + REPLICATE('0',2-LEN(MONTH(TB.Date))) + CAST(Month(TB.Date) AS CHAR(2)) AS Date,

>
>Is there a shorter way of writing it?
>

You could use:

SELECT datepart(yyyy,convert(datetime,TB.Date)) + "/" +
       datepart(mm,convert(datetime,TB.Date)) as Date
...

If you don't need two digit months ('4' vs. '04') you could use:

SELECT year(convert(datetime,TB.Date)) + "/" +
       month(convert(datetime,TB.Date)) as Date
...