How To Get First And Last Day Of Current Month

Use this 

****************** Get the First and Last Day of a Month ******************

SELECT DATEADD(DD,-(DAY(GETDATE() -1)), GETDATE()) AS FirstDate
SELECT DATEADD(DD,-(DAY(GETDATE())), DATEADD(MM, 1, GETDATE())) AS LastDate

However, we want the First and Last day (in words). So, simply embed the two above queries inside the DATENAME() function. Here it is.

SELECT DATENAME(WEEKDAY, DATEADD(DD,-(DAY(GETDATE() -1)), GETDATE())) AS FirstDay
SELECT DATENAME(WEEKDAY, DATEADD(DD,-(DAY(GETDATE())), DATEADD(MM, 1, GETDATE()))) AS LastDay

Yes it will show current month first and last date. If you want first and last date of a particular date then replace GETDATE() with your date parameter.

thank You 

Bhai code direct data show kar ga month k 

here no need parameter

ALTER PROCEDURE [dbo].[sp_GetTop3VolunteerReport]
	--@inVolunteerID int,
	--@inType varchar(100),
	--@inShift varchar(100),  current_date
	@inFromDateTime datetime =  '20220301', --yyyymmdd
	@inToDateTime datetime = '20220331' --yyyymmdd
	--@inPoints int
AS
BEGIN
select	top(3)
			ROW_NUMBER() over (order by temp.TotalPoints desc) as "Rank",
			vol.profilephoto as Photo,
			pos.positionname as Position,
			vol.reportdisplayname as "Volunteer Name",
			vol.GroupName as "Group",
			temp.MPoints as "Morning Points",
			temp.EPoints as "Evening Points",
			temp.ExPoints as "Extra Points",
			temp.TotalPoints as "Total Points",
			temp.MDays as "Morning Days",
			temp.EDays as "Evening Days",
			temp.ExDays as "Extra Days",
			temp.TotalDays as "Total Days",
			temp.TotalDuration as "Total Duration",
			[StartOfMonth] = DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0), 
			[EndOfMonth] = EOMONTH(GETDATE())
	from
	(select volunteer.volunteerpositionid as Position,
			volunteer.volunteerid as VolunteerID,
			SUM(CASE when attendance.shift = 'Morning' then attendance.points else 0 end) as MPoints,
			SUM(CASE when attendance.shift = 'Evening' then attendance.points else 0 end) as EPoints,
			SUM(CASE when attendance.shift = 'Special' then attendance.points else 0 end) as ExPoints,
			SUM(isnull(attendance.points, 0)) as TotalPoints,
			COUNT(CASE when attendance.shift = 'Morning' then attendance.points end) as MDays,
			COUNT(CASE when attendance.shift = 'Evening' then attendance.points end) as EDays,
			COUNT(CASE when attendance.shift = 'Special' then attendance.points end) as ExDays,
			COUNT(attendance.points) as TotalDays,
			--SUM(isnull(CAST(duration/60.0 as DECIMAL(16, 2)), 0)) as TotalDuration
			CAST( ( SUM( isnull( duration, 0 ) )/60 ) + ( ( SUM( isnull( duration, 0 ) )%60 )/100.0 ) as DECIMAL(16, 2) ) as TotalDuration
	from tblvolunteer volunteer
	left outer join tblattendancelog attendance
		on attendance.volunteerid = volunteer.volunteerid
		and attendance.type = 'Present'
	--where (tblattendancelog.volunteerid = @inVolunteerID or @inVolunteerID = 0)
		--and (type = @inType or @inType = '< All >')
		--and (shift = @inShift or @inShift = '< All >')
		and (attendance.dutydatetime between @inFromDateTime and @inToDateTime)
		--and (points = @inPoints or @inPoints = -1)
	where volunteer.isresign = 0
		--and volunteer.volunteerpositionid != 6
	group by volunteer.volunteerpositionid, volunteer.volunteerid
	) temp
	inner join tblvolunteerposition pos
	on temp.Position = pos.volunteerpositionid
	inner join tblvolunteer vol
	on temp.VolunteerID = vol.volunteerid;

END

can u add me on my code