This should get you pointed in the right direction.  Fully expect the heavy hitters to come up with some other great solutions.

-- Create a sample table
DROP TABLE...

I have a plan. I'm learning Spanish. I'm retiring in 18 months and plan to spend a year in Europe with a base in Spain. I'm training to live...

Scott's code is definitely more concise.  Here is another method leveraging LEAD

; WITH TaskData AS
(SELECT *,
        NextTask = LEAD(TaskName, 1,...

I love a good reason to use any of the widow functions.  Thank you to Kaj for some sample data.  I can't tell you how many times I've had to...

Awww man!!  Keep coming west Jeff!  Would love to see you make it to Orange County, CA one of these days.

Oh... Scrubs was SO good.  Very witty and brilliant.

Most watched does not equate to accurate.  They did have to pay out nearly $800 million due to false claims.

Please consider learning standard SQL. We don't have an IFF() construct; that was spreadsheets and perhaps some nonrelational languages. Take the time to write everything out as a CASE...

Couldn't it be as straightforward as this??

SELECT t.[pick your columns]
FROM SomeTable t
INNER JOIN (SELECT [ID#]
            FROM...

This is the output I get.  (In fact I did a copy/paste from my post).

It's Friday afternoon and this was a nice small example.  Here's my offering:

-- Create sample data
DROP TABLE IF EXISTS #Example
CREATE TABLE #Example
    (DayNum INT,
...

I've been a member of this forum for 17 years, mostly a lurker with very occasional posting or replying.  I am the baby Jeff at my company.  My scope isn't...

Actually no, no he cannot. I blocked him years ago...

You may have already found your solution, but here's how I have it configured in one of my reports.  I've obfuscated some names.  In my case, the report is under...

This might be a long shot, but see if this query gives you any insight.  If the subscription is complaining about the parameters, then it's possible it won't even get...