Details details 🙂 Probably should have noticed that

Thanks, I'll keep it in mind. Most of the reports that I run against this data typically starts with:

declare @periodid int

declare @dayofweekid in

declare @route varchar(10)

declare @pttrn char(2)

set....

So we should be...

Yes, will do. I generally break the code down to all the subcomponents so I can see what's going on before implementing, so I'm definitely going to make sure...

Lutz,

That works beautifully! Thank you so much. As for the static code with the case expressions, the problem is that I have some routes with about 70 stops on...

Thanks...thi sis starting to look good. I set up a scenario last night that was very close, but the stops were in the wrong order. Your example looks...

No problem...I look forward to it!

Ok...spent some time to condense the tables to the absolute minimum and still have the sequences etc. Keep in mind that the sequence is not consecutive numbering; this is...

Yes, I suppose it would be helpful to post the full DDL. The problem is that the database I'm using is very multi-faceted and takes a lot of...

EDIT: Got it in the format I want, but hate the solution...

Here's an example of where I am so far. I know I have to convert my array of...

Ah, sorry...Sort of. I've run a Row_Number() function to get a sequence, converted to varchar, then concatenated to the stopname in order to differentiate.

Ex:

Select convert(varchar(4), row_number() over (partition...

Hi Lutz,

Thanks...I'll check out your link. To answer your question about hard-coding Route 202, LP, I'm guessing you mean that I would do something like this with the result...

Hi Steve,

Great article on the fn_gettimerangestamp. I've been using a date table for some time at a few people's suggestions for some a variety of issues at work. ...