So I have a couple of dilemmas. I can create a good table for dbo.Competitors.

CREATE TABLE dbo.Competitors (
    CompetitorID int IDENTITY(1,1) NOT NULL PRIMARY KEY...

That worked. Here I am creating 4 tables.

USE meetscoreslive

--===== If the Competitors table already exists, Drop Table
IF OBJECT_ID('dbo.Competitors','U') IS NOT NULL

I am back for a while. Thank you sgmunson for the example. I have modified it to reflect all the data I need...

I have reduced my 3 query's to the most basic data. From this I will need to output the xml/CSV/JSON files and also create a user interface to select which...

So I think what your are saying is I need to just have one big table like QWomenResultsDay1 with all the records and then output each category to xml/csv/JSON so...

Yes, I do want to code the most efficiently, just beginning like you said. So to start over here are the different tables I will have.

This table...

I am attaching the three queries I have which are not finished yet. The JSON is the format that the app designers want. Please remember this is my first week...

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...

I have been reading that it is not necessary to sort the table? Is that true. I was thinking of sorting the table by AgeGroup/event/avgscore and then outputting the table...

Ok so I need to declare the table first. Here is how the program works. There is the main scoring software that the judges enter the individual scores for. The...