Ok, So here is a little more detail. We have a program (one that I cannot have access to the code) that runs the meets. Judges enter scores and tallies everything and at the end of the meet we print up reports and give out awards. This software output results on the fly to some vendors that repackage it to their web sites. Parents view the results on apps on their phones. Unfortunately our meets are in steel buildings and getting connections is difficult. Also you have to navigate through all meets in the US to find the one your are at. We want to bypass this slowness and broadcast the scores locally. While we do have score boards, the scores only last for 30 sec and we cannot show top scores in each event and age group. The software company that make the scoring program has a small program that output the scores in xml which they let NBC use in college and up so I have to make do with what I have. . I am not using SSMS I think, as I could not figure out how to install and make it work. It was easier to just write the code line by line. I coded html in the past and usually write in a text editor and not a package program. Here is what I have done up to date

• A query to create all the tables(QCreateTables). There is one table for each age group and 4 events plus the AA(all around) scores.(about 25 tables)
• A query to delete all tables(QDeleteTables).
• A query to import the session xml and break it up into the age group/events tables(QWomesResults). This query is running in a loop that I will assign a button to.
• The query is running in a loop as the scoring software is updating the xml output every 5-300 seconds.

Programming I need to do.

• Add to the import query an output to JSON for each age group/event table.
• Create a program that selects the deletes the tables, create new tables, import the data, splits age groups, splits events and outputs to JSON.
• Add an Athletes query
• Add an Rotation query.

I am an old Access programmer so I downloaded Visual studio 2017 and plan to create a program to first delete any existing tables, create the new ones, add the data and output JSON files to a local web serer where our App can access. Our app will have a look up for either lastname, competition number or USAG number. They will then be able to see each events score and where they rank in their age group for each event.

Tim