Getting count of total present and absent in single sql query

shah Momin

Check This Code

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetAttendanceLogweekly]AS
BEGINSET NOCOUNT ON;SELECT YEAR(dutydatetime) [Year], Count(1) [dutydatetime] 
,COUNT(case when @@FETCH_STATUS ='Absent' then 1 end ) as Absent_Count
,Count (Case When @@FETCH_STATUS = 'Present' then 1 end ) as Present_Count
FROM tblattendancelog
GROUP BY YEAR(dutydatetime)
ORDER BY 1,2END

absent and present Count Diffrent Columns with

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty4y ago
Accepted answer
try this
SELECT YEAR(dutydatetime) [Year], Count(1) [dutydatetime]
,COUNT(case when [type] ='Absent' then 1 end ) as Absent_Count
,Count (Case When [type] = 'Present' then 1 end ) as Present_Count
FROM tblattendancelog
GROUP BY YEAR(dutydatetime)
0
shah Momin4y ago
Amit Mohanty Can U Help Me How To Bind Data With Chart

I Will Use Bunifu Chart
0