HOW TO COUNT PRESENT IN CURRENT DATE

Question

 

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