HOW TO COUNT PRESENT IN CURRENT DATE

shah Momin

GO
ALTER PROCEDURE [dbo].[UIPKGREPORTING_spFetchTotalUserCount]
@tpye varchar(50)
AS
BEGINSET NOCOUNT ON;SELECT COUNT(*) FROM tblvolunteerSELECT COUNT(*) FROM tblvolunteerleaverecordDECLARE @MyDateTime DATE = GETDATE();SELECT COUNT(*)  FROM tblattendancelog where type='Present'END

line Number 12 i wan add current date

2 Replies

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

Amit Mohanty4y ago
Accepted answer
Try this
SELECT COUNT(*) FROM tblattendancelog where type='Present' AND dutydatetime = @MyDateTime
0
shah Momin4y ago
@Amit Mohanty how to find same id

1. 12012
2. 12012
3. 12012
4. 12012

1. 12001
2. 12001
3. 12001
4. 12001

Total Count 8 all id in one group 2
0