[求助]sql语句写法的问题[着急]

SET ROWCOUNT 31
SELECT IDENTITY(INT,1,1) AS DAY1 INTO #T FROM SYSOBJECTS
SET ROWCOUNT 0SELECT
    COUNT(*) AS COUNT,
    a.DAY1
FROM
    #t a
LEFT JOIN
    (select
         id,day(datetime) AS DAY1
     from
         company_zc
     where
         convert(char(7),datetime,120)='2005-12') b
ON
    a.DAY1=b.DAY1
GROUP BY a.DAY1
ORDER BY a.DAY1