I think the following index should help performance:

 CREATE INDEX IX_OptionsEOD_1 
     ON dbo.OptionsEOD (UNDERLYING_SYMBOL, ROOT_SYMBOL, EXPIRATION, STRIKE, OPTION_TYPE, QUOTE_DATE)
INCLUDE (CLOSE_PRICE)
;

To increase the performance you could limit the rows the query in the CTE produces by selecting on the QUOTE_DATE  going back a given amount of days to when you...

Another option:

WITH CTE AS
(
    SELECT T1.UNDERLYING_SYMBOL,
           T1.QUOTE_DATE,
       ...

SELECT T1.UNDERLYING_SYMBOL,
       T1.QUOTE_DATE,
       T1.ROOT_SYMBOL,
       T1.EXPIRATION,
    ...

Yes you can, I've upgraded from SQL 2012 to 2019 by just restoring a backup.

DECLARE @YearKey int, 
        @WeekKey int, @CA4 int, 
        @PrevMonthCheck int= -1, 
...

You are getting the new error because ProjectedValue / StartValue is less than 1 (3.22/4.079).

When you raise this to a number greater than 1 (182.5) you get a number very...

The overflow occurs because the exponent in the POWER function is extremely large due to the short time span and high growth rate.

The formula isn't designed to handle cases of...

The expressions you mentioned, such as BETWEEN, EXISTS, IN, LIKE, <, >, =, and others, are often referred to as operators or comparison operators rather than predicates.

In logic, predicates typically...

You are attempting to compute the result of raising 78.94 to the power of 365, which evaluates to approximately 3.27E+692.

This value exceeds the maximum representable number in the float data...

DROP TABLE IF EXISTS #label ;
-- Create the table
CREATE TABLE #label 
(
    plot int,
)

-- Populate the table with sample data
INSERT INTO #label(plot)
VALUES (1), (2),...

25 minutes is quite fast for a...

You can copy it to the clipboard and execute it by pasting into a query window and pressing F5.

But my suggestion was really...

How long does a full load of the DW take?

I think you might want something like this:

WITH CTE AS
(
    SELECT s.DocumentId,
           ROW_NUMBER() OVER...

• This reply was modified 2 years, 2 months ago by Jonathan AC Roberts. Reason: Edited SQL