additional JOIN's and CROSS APPLY's apply to the rectangle defined immediately above it (in order of appearance) within the FROM clause

Thinking inside rectangles is how I...

The link Steve Collins posted is interesting. Got through it, and while I don't quite agree that stored procs create a strangler pattern, I do think in the high...

Check out this video.  The speaker gives a whole laundry list of reasons, a litany of epiphanies, on why SQL Server is not well suited for transaction processing.  Instead, the...

It seems you could use COUNT in the SELECT list.  COUNT always returns an INT even if the FROM clause returns no rows

declare
  @max_num  ...

This is a tricky query.  You have 2 separate aggregations for which the results are then LEFT JOIN'ed by rank.  What I'm not understanding in my own code is why...

Does the query contain WITH (NOLOCK)?

Please run this code and paste the results.  Please replace 'Your-Database-Name'...

An alternative

drop table if exists #title_one_space;
go
select * into #title_one_space from (values
 ('one word')
,('one word two words')
,('one word two words three words')
,('one word two words three words four'))...

It shouldn't be necessary to calculate the LAG twice.  Like Drew's code this factors out another CTE

  WITH 
 ctePrev AS 
(--==== Get the previous Prices...

This is interesting.  Nicely done Jeff.  The AI (ChatGPT-4) was unable to make any improvements to the query marked as the solution.  It never comes up with nothing so it...

The prompt was based on minimal code

this sql code omits a 2nd column with which we could order the rows.  Could you add a date column...

Without a second column containing a date (or some ordinal data type) there's no way to ensure the row ordering is consistent.  Thanks ChatGPT for fixing the data.  You could...

No idea what's meant by the rounding.  Presumably (to get the correct output) there's a '<=' inequality.  To handle the range between 174 and 176 you could create a partial...

Here in New Jersey USA it's too nice of a day to sit behind a screen!  Spring fever in full effect here 🙂  After my 2 o'clock meeting... adios