SELECT Count(type) FROM tblattendancelog WHERE dutydatetime>= DATEADD(day, DATEDIFF(day,0,getdate()), 0)
this uper line edit down code me edit
USE [BiometricDB]
GO
/****** Object: StoredProcedure [dbo].[sp_GetTotalCountReport] Script Date: 26/10/2022 03:28:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_GetTotalCountReport]
AS
BEGIN
-- Get Total Count Report
SELECT
[member].[Total Members], [onleave].[Total Onleave] ,[Present].[Total Present]
FROM
(
-- Total Memebers
SELECT
COUNT(volunteerid) AS [Total Members], 1 AS [Id]
FROM
tblvolunteer
WHERE
[dateofleaving] = '' OR [dateofleaving] IS NULL
) [member] INNER JOIN
(
-- Total OnLeave
SELECT
COUNT(leaverecordid) AS [Total Onleave], 1 AS [Id]
FROM
tblvolunteerleaverecord
WHERE
[todate] >= GETDATE()
) [onleave] ON [member].[Id] = [onleave].[Id]
END