In order to seperate the age groups and events I was repeating the SELECT statement but I had to restate the WITH statements. I thought since the data is...

I had some time today to look at it again. I came up with this solution to import one file.

use meetscoreslive

DECLARE @test-2...

I think this one does that?

USE meetscoreslive

CREATE TABLE #XmlData ([FileName] VARCHAR(500))

--plain vanilla dos dir command with /B switch (bare format)
INSERT...

Ok, after staring at it for 6 hours I see that you are just dumping the whole xml data line by line into ScoresXML. That is why when I execute...

I like that your code gets all the data in from the xml file. Maybe for simplicity I should have one long query that imports 14 separate xml files to...

Ok, that just fried my brain. I have been looking up info all day but still having trouble as this is above my pay grade 😉 I understand what it...

There are two vendors that post scores online. Two issues happen that make it difficult sometimes to get the scores. Most meets are in steel buildings so cell coverage is...