I find that occasionally reading a newspaper or book is like CDs or vinyl albums. An immersive experience in my hands. Nothing digital that disappears when a screen times out....

You would probably  start with something like this example of a dynamic pivot:

https://www.mssqltips.com/sqlservertip/2783/script-to-create-dynamic-pivot-queries-in-sql-server/

Your MyTable data doesn't match your expected output, but I think the idea that each HH has...

Maybe a typo in the explanation highlighted in red below?

What setting of NUMERIC_ROUNDABORT will return an error from this code?

The correct answers are:

SET NUMERIC_ROUNDABORT ON

Explanation

When this is set to

Looks like your flag element might be missing a condition. You have:

CASE WHEN C.Fl=1 and C.Grp=1       THEN 1 ELSE 0 END...

It's fairly hard to tell without tables and data. It doesn't look the query will even run as written.

I was exploring the question/solutions and noticed that neither of the queries grouped the March or May records into one monthly total, so they return mutliple records...

It's about identifying and eliminating equine vampires.

Found a useful tutorial at https://www.youtube.com/watch?v=GlutgLKmyn4

Resets the running total when it becomes negative. I think this works. I added a couple fields to the ridersTest cte, grouped the last query...

Drew, thank you for your reply. Your method seems more like what I was looking for. I modified it just a little by adding your final select as a...

I'm having some difficulty because your sample data and results do not match what is produced by your query. For any situations where timestamps are repeated, like  20-Nov-2022 01:36:02, the...

There are two results that...

With implicit conversions, I believe this returns 0. Also,...

I see this as two parts.

First part is to identify all IT CG combinations that don't have a Week = EOW entry where the EOW is less than the current...

I attempted some dynamic code with the thought that Class might be more than the 3 values in sample data. To get an empty string instead of a null, I...

In your #Setup, you set some ranges that are rounded to whole dollars with one dollar between ranges, so we have to handle those when using them for calculations. I...