Hi all,
I have a database where I am getting averages rates based on an origin/destination (logistics). I currently have it set up to have (1) the user enter the origin, destination, and radius, (2) database will calculate radius distance based on origin/destination and return average rates if they are within this radius.
Example:
Los Angeles CA to Dallas TX ---> $2.50 per mile on average
However, I want to be able to run these in batches instead of one at a time. The problem is that the database will have to calculate the first origin/destination radius, return the average cost per mile, and then continue on to the next one and do the same.
Example:
Los Angeles CA to Dallas TX---> $2.50 per mile on average
Chicago IL to Dallas TX---> $3.50 per mile on average
Boston MA to Dallas TX---> $1.50 per mile on average
I will basically need to run the same queries over and over in order to do this, but I am unsure how (or if it's possible). Any suggestions?
Database with dummy data is attached; requires a PCMiler module so I am unsure if it will work without that, but you can at least get the general idea of what I am trying to accomplish.
IM DB 3.0 - Copy.zip
Thanks so much!