Yet another application where a tally function could be useful.  The projection is off by $1.11 perhaps due to rounding

declare
  @revMTD    ...

Each record has a PatID, Date, Doctor and upto four possible operation procedures (op1 to op4) that a patient may receive. There are 6 possible options for surgical procedure...

Yeah, it sort of tastes like sausage... or that's how they get you to try it.  They ask you "what's your least favorite meat?"  Then tell you it sort of...

select t2.*
from #map m
     join #trades t1 on m.CodeValueFrom=t1.Code
              ...

My father in-law made scrapple,...

My father in-law made scrapple, and my oldest daughter loved it. I really don't remember if he made it for the younger two before he died.

I say to each...

Spam is one thing but don't let anyone convince you to try scrapple.  It's not "the same thing" it's not even "similar" 🙂

It seems you're looking to include the ROW1 column in the GROUP BY and ORDER BY clauses but not in the SELECT list.  Otherwise, it seems to be a standard...

The math could look something like this

declare @data table (app_time varchar(8), 
               ...

Here's a simple way which avoids counting

with
a_cte as (select distinct PartId from #FeaturesvalueA),
b_cte as (select distinct PartId from #FeaturesvalueB),
x_cte as ((select * from a_cte except select *...

Based on the data that's been provided the two tmp_day values are '01' and '02' which don't seem to vary by month.  As to which column is subordinate to the...

An alternative to PIVOT is conditional aggregation.  The sample data provided only contains 1 value for 'tmp_day' which seems to not agree with the output.  So I changed the sample...

In the first paragraph it says "Windowing functions are limited to the SELECT and OVER clause..."  Correction, windowing functions are permitted in both the SELECT list as well as the...

If the array is really JSON then Mark Cowne's answer seems correct.  If it's just a delimited string with repeating fixed length segments then something like this could work

Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können