Set up test data

set statistics io, time off
DROP TABLE IF EXISTS dbo.PATIENTS;

CREATE TABLE dbo.PATIENTS 
(
    FIRST_NAME        varchar(50),
...

Ah... I see my confusion here.  The op posted a recursive CTE where he said it wouldn't work  with the  word RECURSIVE  and Frederico said that RECURSIVE  is not...

I think you might want a recursive common table expression.

Something like this:

DECLARE @n int = 3;
WITH Factorial(F,n) AS 
(
    SELECT 1 ...

I think you might want a recursive common table expression.

Something like this:

DECLARE @n int = 3;
WITH Factorial(F,n) AS 
(
    SELECT 1   ...

You could do with reading this: How to post code problems

DROP TABLE IF EXISTS dbo.PATIENTS;

CREATE TABLE dbo.PATIENTS 
(
    FIRST_NAME  ...

If you use:

SET STATISTICS IO, TIME ON

you will also get the CPU usage for the query.

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