I have the following sql statement that i would like to pad the WEEK column when the length of the digit is 1 with a 0: 01, 02, etc. This is so the order will be proper.
SELECT DATENAME(wk, ASSIGN_DT) AS WEEK, COUNT(CASE_ID) AS CASE_COUNT
WHERE (ASSIGN_DT > '01/01/2007') AND (ASSIGN_DT < '12/31/2007')
GROUP BY DATENAME(wk, ASSIGN_DT)
ORDER BY DATENAME(wk, ASSIGN_DT)
Thanks in advance.