Ah yes, I see that now.  Thanks Jeff.  In my head I did check to make sure the dates within the partition were unique and then told myself "nothing to...

• This reply was modified 1 week, 1 day ago by Steve Collins.

Yes I agree pietlinden has the correct approach imo.  SUM OVER provides a running total without recursion

select *, sum(OpenOpps+CreatedOpps+WonOpps+LostOpps) over (partition by Division order by [Date]) running_total
from...

• This reply was modified 1 week, 1 day ago by Steve Collins.
• This reply was modified 1 week ago by Steve Collins.

DROP TABLE IF EXISTS #data_table;
GO
CREATE TABLE #data_table (
    Id INT PRIMARY KEY,
    Model INT,
    RecordType INT,
  ...

It took some testing to get the recursion working.  From the reference paths it's not clear how to proceed tho.  Maybe you're looking for the maximum level for each ProcedureName?

How do I code "calc1 has error"?  The above code is part of a larger code where results results are passed up from sub-query to parent query so...

Very nice.  The chess app is interesting too.  Could you explain the project structure of the chess app a little more?  There appears to be more than one chess engine

"I am trying to pull the record with ID 198765 out from select query where first and last or full name does not exists."

What seems to be intended is for...

• This reply was modified 4 months, 1 week ago by Steve Collins.

There are examples on the internet of how to recursively assign HIERARCHYID.  A while ago on this forum:

Using hierarchyID

My reply in the SSC forum was based on this Stack...

"a continuous year without any gaps" might mean different things.  This assumes it to mean (any) 365 days in a row

If the EXP_DATE is null does that mean the account...

• This reply was modified 4 months, 1 week ago by Steve Collins.

Hey there why so hasty?  If you'd fixed the script we might've seen some JM t-SQL  It's been a while afaik :).  The query seems nicely done tho.  Presumably uniqueness...

There are...

Afaik there are only two possible values for the Category column: { 'Lessthan8', 'greatherthan8' }.  If that's so the query could rely on EXISTS to handle any duplication

            
April 24, 2025 at 10:26 pm
            
#4583779

            
            
                                                
        

Regarding the precision of the data types

cast(Price as decimal(9,7)) Calculation

The line above CAST's the price (Price) to DECIMAL(9, 7).  Imo this is not a good practice.  When...

My query was insufficient because it applied the factor percentage to the lagged price and not to the lagged calculated price.  It seems recursion is unavoidable.  This query uses a...

Why are you using these data types with this numerical precision?  By making @Factor DECIMAL (9,7) and applying this percentage to a price it adds significance to decimal places to...