I need just the passenger events (0 or o,1).  But I think I may have gotten the answer from a colleague:

SELECT

costCenterCode,

scheduleDate,

tripid,

routeId,

routename,

activityId,

eventOrder,

CASE WHEN eventOrder = MIN(CASE WHEN activityId = 0 THEN...

• This reply was modified 1 year, 1 month ago by  tacy.highland.

Thanks for your feedback Phil,

The reason for the layout of my sample data was just for simplicity.  I inserted my sample data into a physical table and then just used...

I cannot change the underlying dataset query/stored procedure.  The full dataset is returned.  I can only filter the dataset based on parameters selected in the SSRS report so I need...

Any other ideas out there to get the expected results table above?  The query Drew provided was so close....

Here's the expected results, based on the query that you provided above:

CREATE TABLE [dbo].[GroupingExpectedResults](
[RN] [float] NULL,
[LDate] [float] NULL,
[EvstrName] [float] NULL,
[ClientID] [float] NULL,
[BookingID] [float] NULL,
[Address] [nvarchar](255) NULL,
[PickDropHour] [float]...

Thanks Drew! I would say the format of the results you provided would work fine since it's assigning a value to all the trips which belong together in the grouping,...

Yes, I'm looking for a group number for each group.  As long as they're some type of number/value that designates the grouping of trips together, I don't care what the...

How would your option allow me to calculate the full travel time of the entire group?  Wouldn't it just give the travel time per each group instead of the whole? ...

You are a veritable font of information, sir.  Thank you.

I actually feel much more educated on the subject now; I might actually be able to pose an intelligent response on...

Thanks, Ant-Green!

Would this link specifically address zero-day patching or is it just the usual monthly/regular patching here?  And we have SQL 2016, which isn't included in this specific link (2017...

ugh.  You're right.  I completely forgot about the OPENQUERY inside the stored procs I'm trying to execute.

Ok, well, perhaps this won't work for what I need to do....

Apologies for not including more detail on the issue.  The error is"An INSERT EXEC statement cannot be nested."

I tried changing the table variable to a temp table but still get...

That one didn't work either, but the "IN" operator in the table filter jogged my memory on something I had to do before with Split.  I tried this and it...

Yeah, that's not working either:

=IIF(Parameters!ProviderID.Value = 1,"REG1,SYS", "" )

Wouldn't all of these filters have to be true in order to display anything?  They can't all be true...

Ok, (honestly, I'm not intentionally trying to be obtuse here), but is this what you mean?

And the expression in the "Value" is =IIF(Parameters!ProviderID.Value = 1,"REG1","SYS" ) ...