That's exactly what I was looking for!

If I wanted to include a sequence number (1,2,3,,,) for each point based on the order within the XML, how would I do that?

Well, can I do this without putting the XML into a table with a key?

Since the XML is in a variable, @theXML, can I get the detail out of it...

Wow. That's disappointing.

Tha

If that's the case, what would be the recommended way to indicate a set of "alias" field names to use for presentation, whether for exporting data, linking to Access databases,...

I don't know enough to answer that question.

The databases are on two different servers with different versions of SQL Server.

My DBA is aware of the problem I'm having, so, with...

The view has no out of the ordinary settings that I'm aware of. I created it by using the designer window, selecting the tables involved, checking the columns...

I'm sorry I misunderstood your question.

Yes, the guid went into the correct column.

I took the sql of the view verbatim and replaced the select * with that sql statement, so yes, I had the same number of fields.

I don't want to use...

If I substitute the complete SQL of the view in the insert,

Insert into output_table

Select distinct TOP (100) PERCENT field1, field2, NULL as SPAuditID

...

Thanks for testing it out.

I don't see how the column order can be playing a part, because, if I set the value of SPAuditID to NEWID() in the view, then...

I have no defaults or triggers on my output table.

I've scripted out my table definition as a Create Table statement and have attached it here. Maybe that...

In my view, the part of the select has that deals with that guid field has

NULL AS SPAuditID

I know my fields are all in corresponding order in my insert statement,...