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...