Create Stored Procedure for Alternative Saturdays

Hi,

How do you know which saturday is working saturday.

Here is the query to display everyweek saturday date between the daterange check this.

Declare @FromDate VARCHAR(20) = '2015-08-01'--DATEADD(mm,-12,getdate())

Declare @ToDate VARCHAR(20) = '2016-08-06'--DATEADD(mm, 1, getdate())

-- used for the pivot table result

DECLARE @MyColumns AS NVARCHAR(MAX),

@SQLquery AS NVARCHAR(MAX)

-- 2.This Temp table is to created for get all the days between the start date and end date to display as the Column Header

--2.Start /////////////

IF OBJECT_ID('tempdb..#TEMP_EveryWk_Sndays') IS NOT NULL

DROP TABLE #TEMP_EveryWk_Sndays

DECLARE @TOTALCount INT

Select @TOTALCount= DATEDIFF(dd,@FromDate,@ToDate);

WITH d AS

(

SELECT top (@TOTALCount) AllDays = DATEADD(DAY, ROW_NUMBER()

OVER (ORDER BY object_id), REPLACE(@FromDate,'-',''))

FROM sys.all_objects

)

SELECT distinct DATEADD(DAY, 0 - DATEPART(WEEKDAY, AllDays), CAST(AllDays AS DATE)) as Saturday

into #TEMP_EveryWk_Sndays

FROM d

where

AllDays <= @ToDate

AND AllDays >= @FromDate

select * from #TEMP_EveryWk_Sndays

1 Reply

Know the answer? Post it — somebody with the same question will find it here.