用 count(case 条件 when ... then ... end ) as 库存 , SUBSTRING(convert(varchar(10),AttendanceDate,23),1,7) as 年月
查询当年
select * from TABLERecords where
DATEPART(mm, AttendanceDate) = DATEPART(mm, GETDATE()) and DATEPART(yy, AttendanceDate) = DATEPART(yy, GETDATE())