How do I select month with leading zeroes in T-SQL

SQL Server doesn't provide leading zeroes in a month selection, so you'll have to add them yourself. The easiest way to do this is probably to create a two- or three-digit string and taking a RIGHT() substring to select the rightmost two digits.

Example:

RIGHT('0' + CONVERT(VARCHAR(2), MONTH(getdate()))