Lynn Pettis (7/19/2012)

---

capn.hector (7/19/2012)

---

the...

Sean Lange (7/19/2012)

---

I think you just did. 😀

Most...

capn.hector (7/19/2012)

---

the route to...

You could also talk to some of the small non-profit organizations in your area about volunteering your time to help them with database base applications. Some may already be...

djackson 22568 (7/19/2012)

---

Tao Klerks (7/19/2012)

---

OK, I didn't understand the reference the...

The hard part was the initial code. Making the mods is just knowing what it is doing and having a better understanding of the data upon which it must...

Okay, new update to my code:

WITH

/* Create the dynamic tally table (0 based) ...

Looking at the sample data, looks like we have multiple entries for the same route. I need to modify my code a bit more to handle this additional possibility.

Hold on, I have a problem.....

Converted your temp table into a permanent table (created it in a separate query window from my code).

Here is my updated code based on your current sample data (i.e. we...

Or do we wrap the data around on the display?

Another assumption here, you want to display the pivot data out beyond 23:45, correct?

tacy.highland (7/19/2012)

---

That would be exactly right:

INSERT INTO #Schedules_RC

(

Route

, Start_Time

, End_Time

...

You may want to extend your sample data, as this will result in modifications to the code. Also, how does this change how the data is presented?

Also, spanning...

tacy.highland (7/19/2012)

---

Times could span days but you'd know that if it has a starttime in regular time format and an endtime in 29 hour clock format (ie 2500 - 2859).

This...