As an example, I use a simple select statement to return how many times a team has played on a rink. The available rinks in my example are 4, 5 and 6. I have attached a snapshot of the table rows returned.
Team, RinkNum, max(PlayedOnRink) as RinkUsedNum
RinkNum = 4 or RinkNum = 5 or RinkNum = 6
I also have the next match array and in this example, it is DCAEBF. I split into these 3 matches:
D v C
A v E
B v F
and I need to assign each match the best rinks to use and that is the rinks they have played on the least. It is important in bowls that teams don't keep playing on the same rink and usage for teams is distributed as evenly as possible.
I need to somehow take into account the table rows returned - for example, it shows Team A has played on Rink 4 twice already so shouldn't be assigned that rink, Team F has played on Rink 5 twice so shouldn't be assigned that rink.
The best result would be D v C is assigned Rink 4, A v E is assigned Rink 5 and B v F assigned Rink 6.
I don't know how much to offer for this project because I don't know what's involved so I've set it as a micro project £20.00 but will pay more if necessary. Thanks for looking.
I can efficiently assist you with query development because I am Senior SQL Developer having 10-plus years of professional experience and highly advanced expertise in implementation of complex enterprise SQL solutions.
13 pekerja bebas membida secara purata £35 untuk pekerjaan ini
Hi there, Share me your db dump, and i have read your requirement. I think it can be done. i take payment once validated. I have 8 plus years of exp across various DB platforms. Regards, Gopal
Hi Client! Your project is very interesting for me and also I have good experience in your project. If you hire me, you will get the wonderful results you need. I will wait your response. Thanks for reading my bid.