I need to get records from first saturday of february

DECLARE @StartDate DATETIME = '2010-01-14',@EndDate DATETIME = '2019-5-05',@Month smallint = 3;

WITH

cteDates AS

(

SELECT TOP (DATEDIFF(mm,@StartDate,@EndDate) + 1)MonthDate = DATEADD(mm,DATEDIFF(mm,0,@StartDate) + (ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) -1),0)

FROM sys.all_columns ac1

CROSS JOIN sys.all_columns ac2

)

SELECT DATEADD(dd,(7 - (DATEPART(dw,MonthDate) + @@DATEFIRST) % 7) % 7,MonthDate) As Date

,YEAR(MonthDate) As Year

from cteDates where MONTH(MonthDate) = @Month

Hi try this

 

Suraj