Viewing 10 posts - 196 through 205 (of 205 total)
Thank you, Seth, for all your assistance. You have been an immense help; I did move forward a bit on this process, thanks to some of your suggestions!
October 20, 2009 at 8:03 pm
...Anyone else out there have any ideas for me?
October 19, 2009 at 10:21 am
I'm hoping I followed directions correctly...
I've posted some sample data, just for 2 routes, from the temp table: (Note, I excluded clientname, for obvious reasons)
--Create the temp table:
CREATE TABLE #Temp(
October 16, 2009 at 11:07 pm
I think I figured out why the Odometers are not populating quite right...
My code separates out by Activity in two different cases for two different odoms: (note in the first...
October 16, 2009 at 3:47 pm
You are awesome. This is good stuff!
Ok, let's see if I can break this down...
For each route, there are multiple Activities (pick or drop). For every pick there...
October 16, 2009 at 3:25 pm
I'm open to hearing whatever you got.
As far as the temp table goes, I technically could've used joins but it was much simpler for me to use the view which...
October 16, 2009 at 12:51 pm
Oh! and I read your post on the sample data....but I'm not quite sure how to go about doing that for this exercise. I wouldn't know where to begin. (eek!...
October 16, 2009 at 10:58 am
Ok, here goes... let me know if i need to clarify. (and thank you for your help!)
------To find actual mileage based on odometers:
----FILL TEMP TABLE WITH ALL RECORDS FROM...
October 16, 2009 at 10:56 am
These are great queries, thanks everyone. It just seems I've opened up a whole new can of worms with this. Apparently my subscriptions are scattered throughout several servers,...
October 6, 2009 at 10:04 am
Thank you for the info! I'll give it a try.
October 6, 2009 at 8:54 am