Ha yeah I was reluctant to test it out.  Sorry for the syntax issues.  Originally I had a table CREATE statement but then switched to SELECT INTO because that's more...

How about creating a giant temp table from a CROSS JOIN using 2 fnTally functions.  Then join the temp table to itself forcing a HASH JOIN with tiny memory grants...

Assuming this is dev or the table is empty, DROP and recreate with the proper column type and default.  Something like this

drop table if exists dbo.latest_info;
go
create table...

You're looking to set the DEFAULT value of the publish_date column to be the current Unix timestamp?  If so the proper column type would be BIGINT.  SQL Server’s native datetime...

Summary
+ Input: long varchar text; max line width W.
+ Walk left-to-right, one word at a time.
+ Separators: space; CR/LF are hard line breaks.
+ For each word:
 ...

If there are alternate code paths which depend on the client then spare a thought for the optimizer. This pattern implies parameter sniffing imo.  To the extent there are separate...

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 2 months, 2 weeks 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 2 months, 2 weeks ago by Steve Collins.
• This reply was modified 2 months, 2 weeks 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 6 months, 2 weeks 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 6 months, 2 weeks ago by Steve Collins.