Sql Code edit please

Try this

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 [Total Members] = COUNT([volunteerid]), 
		        [Id] = 1
	       FROM [tblvolunteer]
	      WHERE [dateofleaving] = '' 
		     OR [dateofleaving] IS NULL
       ) [member] 
	   INNER JOIN
       (
	     -- Total OnLeave
	     SELECT [Total Onleave] = COUNT([leaverecordid]), 
		        [Id] = 1
	       FROM [tblvolunteerleaverecord]
	      WHERE [todate] >= GETDATE()
       ) [onleave] ON [member].[Id] = [onleave].[Id] 
	   INNER JOIN
       (
         -- Total Present
         SELECT [Total Present] = COUNT([type]), 
		        [Id] = 1
           FROM [tblattendancelog]
	      WHERE [dutydatetime] >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0)
       ) [present] ON [member].[Id] = [present].[Id]
END