Closed

Create database query

I do a bit of sports trading as a hobby, mainly on the horse racing markets. I maintain a database which I update daily that currently contains 400k+ records. Each morning I download a list of horses due to race that day and manually check them against the database. This is quite time-consuming.

What I require is some mechanism where the daily list of runners is queried against the database and a report generated as a separate file showing the headings of the database file. There can be multiple returns for a horse or none if the horse hasn't run previously.

Ideally, if not too complicated, it would be nice to have the database headings as selectable items in the query mechanism so that headings may be included or omitted as required. If it's not practical to include all headings I can reduce them to those that I feel are necessary.

I am attaching a sample file with two tabs showing samples the daily runner list and the database.

Skills: MySQL, Database Programming, SQL, Software Architecture, Excel VBA

See more: how to create database in mysql workbench, create database query in phpmyadmin, how to create database in sql server 2017 management studio, mysql create database and user, sql create database if not exists, create database postgres, create table, how to create database in sql server 2014

About the Employer:
( 0 reviews ) Dublin, Ireland

Project ID: #25754039

60 freelancers are bidding on average €481 for this job

gopalvora

Hi i can work for Create database query i am expert at , SQL , Software Architecture , MySQL , Database Programming , Excel VBA So send me Private message at PMB so we can discuss more about it Thanks

€500 EUR in 7 days
(298 Reviews)
7.9
Neno585

Hello, this what you described is absolutely doable and based on which database management system you are using, fairly simple. Even the functionality where you choose your headers is possible via dynamic SQL. All of t More

€350 EUR in 7 days
(35 Reviews)
7.5
asin1987

WILL DO THE JOB IN NO TIME. Dear Employer, I understand you need to compare the horses daily data with your Database and produce results. Please message me, I will do the job in no time. We can talk about price if ne More

€500 EUR in 2 days
(163 Reviews)
7.5
shaktistanwar

Hi I am a technical evangelist, developer and can do this task for you. I have more than 15 years of experience in software development and am a microsoft certified professional.I have strong work experience in xamarin More

€500 EUR in 7 days
(63 Reviews)
7.3
pofilippov

Hello. I can do your project. About me: — 9+ year of experience. — Any tasks — Improve your ideas

€500 EUR in 8 days
(30 Reviews)
6.8
zekovicm

Hi there I also have lot of experience with scraping betting/sports data and storing that in the database and creating different queries from it. Please feel free to initiate the chat so that we can discuss further de More

€450 EUR in 4 days
(38 Reviews)
6.6
sr33raj

Hello, I can develop a database oriented system for your horse race needs. Let me know when we can discuss. Thanks

€750 EUR in 20 days
(208 Reviews)
6.3
elbruninh

⭐⭐⭐Hi, i'm interested, could you give me more details please? do you have the database on MySql or Excel file? can you send me a sample output report? i can do it with PHP + MySql + gentelella dashboard https://colorli More

€350 EUR in 1 day
(72 Reviews)
6.3
VladimirLilenko

Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko? More

€300 EUR in 3 days
(65 Reviews)
5.8
BitSDestiny

With my 12+ years of Software Development experience like to work on your project,Please see my reviews to consider me as your development member. ASP.Net, C#, VB.Net, MVC, WPF,Android Application,iOS Application, Vis More

€250 EUR in 15 days
(47 Reviews)
5.9
urielbaray

First of all, I hope you and your family are safe and healthy. I have read your project and I can do it. Actually I have done a Horse Racing Software so I am familiar with the databases See video here: https://1drv.m More

€450 EUR in 7 days
(22 Reviews)
5.7
sloker18

With respect to this project I would like to present myself as a candidate for your consideration. I read your project descriptions carefully. I checked the attached workbook as well… I am proficient with Microsoft Exc More

€500 EUR in 5 days
(54 Reviews)
5.7
Wipitech

My name is Teoh, a senior web developer. I read your description and checked your attached database file. Actually, everyday updating database manually is quite time-consuming. If we set cron jobs on backend, the backe More

€500 EUR in 7 days
(3 Reviews)
5.5
zu02

Hello I hope all's well with you. Based on your proposal and your Excel file I think best way to make it in Ms Access. If this will work for you , then go on! I'm professional Ms Access/Excel/vba coder. I'm coding More

€750 EUR in 7 days
(27 Reviews)
5.6
mateenbhatti94

Dear sir I can create a button in excel which will get you result from using this mechanism. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, More

€500 EUR in 2 days
(14 Reviews)
5.0
mquesada90

Hello. Thank you for your posting. I am Marvin, a database expert. As a member of PF program, I have enough experiences in different databases and its configuration & optimization, querying and monitoring. I would be h More

€700 EUR in 7 days
(4 Reviews)
4.7
tutulsoft

--20 Years Database Expert with Excel ----- I am very much interested to update your Excel system with full automated system to reduce manual work --we need discuss to start --thanks

€250 EUR in 7 days
(14 Reviews)
5.1
dat2na

Greetings, I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have More

€833 EUR in 2 days
(4 Reviews)
4.4
ashupathania

I have around 8 years of experience in sql development and MSBI technology. I will create a package for you import your data and export it using the select statement in desired format.

€500 EUR in 5 days
(28 Reviews)
4.8
uridevman

Hello In order to save the time for checking some lists from database, I can make script to check automatically instead of hand-working. It will be possible for php and query or python. Ready to start immediately. Tha More

€300 EUR in 4 days
(4 Reviews)
3.8