Thanks everyone was able to get the monday's from Getdate()

SELECT DATEADD(wk, -5, DATEADD(DAY, -5-DATEPART(WEEKDAY, GETDATE()), DATEDIFF(dd, 0, GETDATE())))
SELECT DATEADD(wk, -4, DATEADD(DAY, -5-DATEPART(WEEKDAY, GETDATE()), DATEDIFF(dd, 0, GETDATE())))
SELECT...

the % for most of them shows 0 ...if it is negative needs to show negative ......normally is this right way to calculate the %varience?

Select *,CASE WHEN Currentdate = 0 then (PriorDate * 100.0/ [Date-2])
    ELSE 
                CASE WHEN PriorDate=0 THEN (Currentdate * 100.0 / [Date-2])
       ...

CREATE TABLE Dbo.Percentagecalculation
(

Currentdate int
,PriorDate int
,[7DayAvg] Int
,[14dayavg] Int
,[Date-2] int)

INSERT iNTO Dbo.Percentagecalculation VALUES(607     ,480     ,524     ,506     ,590)
GO
INSERT iNTO Dbo.Percentagecalculation...

thank you it works.

DECLARE @filedirectory NVARCHAR(100) = 'E:\Temp\Filename\'
DECLARE @command NVARCHAR(1000) = 'dir /B "'+ @filedirectory +'"'
IF OBJECT_ID('TEMPDB..#tmp') IS NOT NULL
DROP TABLE #tmp
--Loop through all of the files
CREATE TABLE...

We already have stage Table and first we load to stage and then actual DW. But the requirement mentions to evn stop loading process and send email if you find...