how would you want the sum, per route or per 15 min period. which one will determine which way to go about getting the sums

Here is a way to do it might not be the best but it should work

With MyCTE (#ID,RouteID,Seq,BuildingID,StreetName,StreetNr,StreetAddInfo)

--data changed a little so its not in alphabetical order for sequence to...

some readily consumable sample data would really help to get you an answer. im currently formating your sample data and will get back to you soon.

the route to route#...

tacy.highland (7/19/2012)

---

Here's another trick.

So now that the hours are defined in 15 increments, if I wanted to specify "break" periods where the route is not in service during their start/end...

tacy.highland (7/18/2012)

---

I got it. (Didn't think about adding the original Tally cte into the existing one.)

One question on how it's calculating: If i have a route starting at 0900 and...

i do hope you go through and follow through the logic of what i did and don't just blindly use it. research CTE's and Pivot tables and try to...

tacy.highland (7/18/2012)

---

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...

ok after much work here is the table insert and pivot sample to get you the output you want. this assumes much so use what you will and dont...

if you change your data structure and go with a pivot for the times to get them lined up you can use something like this:

CREATE TABLE busroutetime (

BusRoute INT,

TimeOfDay INT,

InService...

i have a question why branch1 has a groupid of 0 both times and branch4 has a group id of 2 and 0. i think a data set a...

a simple google search will yeild several methods this is one:

DECLARE @Rowcount INT = 1

WHILE @Rowcount > 0

BEGIN

DELETE TOP (5000)

FROM Tally

SET @Rowcount = @@ROWCOUNT

END

and another:

DECLARE...

SQLSACT (7/17/2012)

---

Hi All

How would I setup a script to copy files from a shared location on one server, to a shared location on another server?

The extension of the files would...

i would like to see that

maby 2 months ago or so...