SQL1

--1. Find weekOff (Saturday/Sunday) between two days

DECLARE @startDate DATETIME='01-01-2023';
DECLARE @endDate DATETIME='01-31-2023';

  WITH CTE(date_list,DAY_NAME) AS (
      SELECT @StartDate,DATENAME(WEEKDAY,@StartDate)
      UNION ALL
      SELECT DATEADD(day,1,date_list),DATENAME(WEEKDAY,DATEADD(day,1,date_list)) FROM CTE
      WHERE date_list<@EndDate	    
  )
  
  select * from CTE WHERE DAY_NAME='Saturday' OR DAY_NAME='Sunday'