Yes it could be put in the same function

It's true...

That's the one I use.  There are others out there and if you're...

It seems the query is performing a partial cross join.  The cross join could be replaced by a tally function and window (rows between 30 preceding and current row)...

It seems safest to COUNT(DISTINCT CATEGORY) with GROUP BY PartId.  It's not clear if it's necessary to join back to the table to SELECT other CategoryIds.  If other CategoryIds (than...

Suppose there's a table of weekend workdays with "Makeup day after St. Patricks Day" in it.  The weekend workday(s) could be included in the query using OR EXISTS and a...

Suppose there's a table of holidays with St Patrick's Day in it.  The holiday(s) could be excluded in the query using WHERE NOT EXISTS and a correlated subquery.  Because St...

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...