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

I am getting this error.  How do I fix it?

(573 rows affected)
Msg 468, Level 16, State 9, Line 14
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and...

drop table if exists #trades;
go
create table #trades(
  underlying_symbol         varchar(10) not null,
  trade_date     ...

From the tables provided what is the expected result?

If it were only the 100th row maybe OFFSET paging.  Since it's both the aggregation of the rows as well as the 100th value you could try using ROW_NUMBER in...

Nice one Jeff.  That's a good looking query.  It makes good use of '+'  as the NULL respecting concatenation operator.  My initial thought was to reverse the string and use...

All right it sounds tedious.  To differentiate the duplicates you're looking to add 1, 2, 3, ... n hours to the datetime column, EffectiveDate.  Of course, this could create new...

Maybe 3 WHERE clause conditions could be sufficient (A and B or C):

A) the existing criteria

B) NOT College ID 06 under Municipality 25002

C) municipal_ID equals 4269005 (which would be inclusive...

Or it could be 5 or ?

In conclusion I would recommend a crosstab-type query.  Conventions of language don't always map to relational operators.  And often predictably so.  Language conventions that is.    Are you sure you're...

Just scanning the code and there are nested Try/Catch and a transaction is declared but rollback only appears in 1 of the TRY code blocks.  That's concerning imo.  Could you...