wafw1971 (2/21/2013)
Hi KingstonI didn't think of that and I should have, each price is a daily price so if the price for a pitch is £9.00 on the 31/01/2010 and the price of the pitch is £9.70 for the 01/01/2011 then the total should be £18.70
And after looking at the data that has not happened.
How do we amend the code to compensate for that?
This will be a bit complex
I will try and post a solution as soon as I get some time for that
Meanwhile I think somebody else might help as well..
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/