My apologies, I've not used cte's before but I know something about how they need to be used after they're created. But I'm just not putting that tally table...

Thank you so much. I think you might have gotten it, looking at what your output is, but when I tried running the code I'm getting an error: "Invalid object...

Here's sample data:

CREATE TABLE #mytable

(

Route INT

...

So I found another query that does something similar, but includes every 15 min increment of the day, and it's still in the wrong format:

Declare @Schedule table (Starttm datetime, endtm...

Ok. So that kind of works.

I'm trying to build it as a matrix, with the route number as a row, and each 15 min increment (for the whole day) listed...

Thanks so much.

However, I ran into issues recreating your cteTally table. I took a look at the link you provided for creating the tally table but I...

The table this query would be pulling from is literally just 3 columns: Route INT, Starttime SMALLDATETIME, Endtime SMALLDATETIME. The start/end time could be in some other format if...

If the route spans two days like in your example, it should still just show how many minutes it's in service for each 15 increment. Like at 1145 =...

No, there's no trigger and no constraints. I'll see if i can set up a trace on the table and see if that helps.

Good suggestion. Any other thoughts? Anyone...

I think i just answered my own question....

Figured out how to use the Built-In fields from within the Parameters section of the dataset.

🙂

I think I'll have to resort to #2.

It seems to theoretically be the simplest way to solve the situation, even though I was hoping to avoid going that route.

Thank you...

As far as the data goes, it gets complicated.

I just wondered how someone might approach a situation where a merge statement updates all rows of data in a...

Ok, figured it out. (After much hair-pulling.)

Knew something was just not right with the provider parameter. I was looking at the @Provider parameter itself, all the properties, verifying...

It was worth a shot. But...no luck. Same issue. I'm only able to see data for all providers. I've not once, with this Iif statement, been able to see...

It's set as a single value. I've never used the "Allow multiple values" option in the Parameter Properties before. Don't know how it even works. (?)

I'm willing to...