Cacher is the code snippet organizer for pro developers

Declare @zeroLength int; SET @zeroLength = 2
SELECT RIGHT(REPLICATE('0', @zeroLength) + CAST(DATEPART(week, GETDATE()) AS VARCHAR(5)), @zeroLength)