So is there meaning for the M.A.nodes etc or can you use what ever combo letters you want as long as the format is the same. ie X.X.nodes

I am importing the session data and am having trouble understanding. Here is the code.
-- Start Place
Select
M.A.value('@Type','varchar(10)') As [Type],
M.A.value('@EventID','varchar(10)') As EventID,

Can someone recommend the best way to output my query's to a .json(txt) file. There are the ways I have been reading about. My project is a simple database which...

So I am trying to  output the query to a .txt(.json) file and am really having a hard time. I have used  BCP, xp_cmdshell and various others. They all seem...

Instead of joining two tables data with a JOIN statement I just added the firstname, lastname and AG to the scores table. Would that be the best way?

I changed it to get 3 decimal places,
SC.S.value('@avgscore', 'decimal(10,3)' ) As AvgScore,

One thing I noticed is the Event_Total table has extra data in...

Ok so here is the meat and potatoes. I have 4 tables which are Athletes, Scores, Places and Event_Total. I am using Event Total table as it has all the...

I feel...

Ok, I am getting somewhere. I will post the whole solution but I am having trouble in one spot. I am sorting on the Avgscore column and since it is...

That worked but now it is in one line and it gets cut off after the max 8192 char count for a column. The JSON output is the last code....

I tried this but no change. I am running out of options.
UPDATE #Event_Total SET Judge1Score = REPLACE(Judge1Score,CHAR(13),'')
UPDATE #Event_Total SET Judge2Score = REPLACE(Judge2Score,CHAR(13),'')
UPDATE #Event_Total SET...