Please continue all further posting here. By starting a new thread you are just going to fragment any responses you get and everyone is going to get frustrated.

Don't get...

One last thing, don't tell us how it must be done. Nothing wrong with saying how you would like to see it, but trust us to look at the...

ColdCoffee (7/20/2012)

---

Did u see my post ? can you give me the data you provided in a readily-usable...

I'll keep it short. It depends. How many rows of data are you putting in the #tmp or @tmp? How are you using #tmp or @tmp.

The best thing...

Okay, once I finally decided to look at the code again after getting home, this is what I came up with base on your post about totals. Nothing big,...

tacy.highland (7/19/2012)

---

I can see value in getting both the sum per route and sum for each 15 min period. So it would be adding a grand total row (summing...

I can partially answer your question:

WITH

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

As I stated earlier, I over thought the question. I actually accept that I got it wrong. I just also stated that it was still possible to revert...

Is it too early to ask about the additional changes that need to be made?

Remember, sample data and expected results. As we build, keep the sample data from previous...

If it isn't the primary file group you could try this...

Here is a dumb question, in what file group does your data reside?

If you look carefully at my code you may notice something. Starting at the top, each piece that follows either builds upon that piece or combines two pieces together...

SQL ORACLE (7/19/2012)

---

We need to truncate the log to release the...

You should note that some of what I am saying above is very basic and there is much more to most of it. Just not sure if it can...

tacy.highland (7/19/2012)

---

Well I'm more than happy to gush in copious amounts about how everyone has been so incredibly helpful and knowledgeable. This has gone way above and beyond my...