select * from tb where RTRIM(SubjectYear) + '-' + (SubjectMonth) + '-1' BETWEEN '2005-7-1' AND dateadd(ms,-1,'2006-7-1')
SELECT CONVERT(VARCHAR(7),CAST(ltrim(年)+'-'+ltrim(月)+'-'+'01' AS DATETIME)),count(*) FROM 表 GROUP BY CONVERT(VARCHAR(7),CAST(ltrim(年)+'-'+ltrim(月)+'-'+'01' AS DATETIME)) BETWEEN '2005-07' AND '2006-08'
(SubjectYear+SubjectMonth) BETWEEN '2005-07' and '2006-06 ' 年与月必须一一对应
where RTRIM(SubjectYear) + '-' + (SubjectMonth) + '-1' BETWEEN '2005-7-1' AND dateadd(ms,-1,'2006-7-1')
GROUP BY CONVERT(VARCHAR(7),CAST(ltrim(年)+'-'+ltrim(月)+'-'+'01' AS DATETIME)) BETWEEN '2005-07' AND '2006-08'
年与月必须一一对应