It works inside the sp. Thank you.

No. Outside. I created a table, inserted one record and then tried to run:

IF EXISTS(SELECT 1 FROM dbo._proc_control_table WHERE Proc_Name = 'sp_Populate_NEW_NEW')

BEGIN

RAISERROR('This proc is already running, please wait for it...

Scott,

I tried this code, however have an error for RETURN -1:

Msg 178, Level 15, State 1, Line 6

A RETURN statement with a return value cannot be used in this context.

Advice?

Thanks a lot ...

Scott, just naïve question (you know I'm not a guru ... so far) in your code the code to halt the sp execution is missing ... after we did all...

Thank you ... We will try it ...

This is the code from Suprotim Agarwal - another use of recursive CTE

DECLARE

@StartDate DATETIME,

@EndDate DATETIME

SELECT

@StartDate = '01 Jan 2019',

@EndDate = '31 Dec 2019'

-- Populate CTE with the 1st date of...

Sorry it does not load .sql

I'm using recursive CTE (see attached) to create a lookup table.

FROM tblEDData
Sorry

Base table ED_Table: Just one clustered.
For calculations:
vw_ED_Time_Calc

Each column has its own median.

Sorry, I tried to attach .sql

Here is the data