I KNEW someone has done this before.. Now I don't have to look like a complete idiot to one of my subordinates and go ask them for help. ...

The idea is that I get these files on a weekly basis. I could spend 10 minutes fixing the spreadsheet, or I could code a solution and never touch...

Jeff,

As usual, thanks for the info. HOWEVER, this time I'm only giving you 3 out of 5 stars since you weren't able to read my mind this time. 😀

The...

an update to this:

The exec staff got involved in this. Yet another proc showed up that "just did xyz" and they decided they'd had enough. The person in...

I must be stupid. I'm not seeing it. Closest I get is Forced Execution Value Int32 or Int64.....

The 2 columns that uniquely ID a record are from a different table (the source of the trouble) but do not relate to the other information. The "other" information...

John,

PK constraints are def. on my radar... I'm on a quest to streamline a few things so indexes are bubbleing to the top right now...

Thanks for the reply.

very much so.... very very much so...

Thanks for asking....

OUTER APPLY??? What's this OUTER APPLY stuff?? No one told me about that???

This XQuery stuff is SEXY!!

To give you an idea of what I'm facing... Here's a short piece of the full XML issue....

<SEARCHREQUESTRESULT><DOCUMENTS><DOCUMENTDETAIL><DOCUMENTDATE/><CONSIDERATIONAMOUNT>0</CONSIDERATIONAMOUNT><BOOK/><PAGE/><REFERENCENUMBER>APPOINT TRUSTEE FOR POWER OF SALE</REFERENCENUMBER><NOTES/><RETURNEDTO/><PARTIES><PARTY><ID>940</ID><NAME>MARINER HOUSE COUNCIL OF CO-OWNERS INC</NAME><ADDITIONALNAME/><PARTYTYPEID>1</PARTYTYPEID><TYPE/><ADDRESS1/><ADDRESS2/><CITY/><STATE/><ZIPCODE/><ATTRIBUTE/><SESSIONID>0</SESSIONID></PARTY><PARTY><ID>941</ID><NAME>DOYLE</NAME><ADDITIONALNAME>PATRICK F</ADDITIONALNAME><PARTYTYPEID>2</PARTYTYPEID><TYPE/><ADDRESS1/><ADDRESS2/><CITY/><STATE/><ZIPCODE/><ATTRIBUTE/><SESSIONID>0</SESSIONID></PARTY><PARTY><ID>942</ID><NAME>BETTISON</NAME><ADDITIONALNAME>DENNIS R</ADDITIONALNAME><PARTYTYPEID>2</PARTYTYPEID><TYPE/><ADDRESS1/><ADDRESS2/><CITY/><STATE/><ZIPCODE/><ATTRIBUTE/><SESSIONID>0</SESSIONID></PARTY><PARTY><ID>943</ID><NAME>APFFEL</NAME><ADDITIONALNAME>DARRELL...

Ok dude... could you look at this and see if there is an easier way? Thy Column I have listed as DocumentID is pivotal to the entire recordset. ...

If this works I am going to name my kids after you

Here's what I came up with...

SELECT

Kachunk.query('

for $NAME in /SEARCHREQUESTRESULT/DOCUMENTS/DOCUMENTDETAIL/PARTIES/PARTY/NAME

return string(concat($NAME,''|''))

') Party_2

FROM

[dbo].[XML_Convert]

In that same node, there is...

This is AWESOME... I wasn't drilling down far enough is what you're basically showing me... BUT... Here's what I don't get....

There are 3 parties in this string......

You're right. I traced it back to the original source and it turns out it was a database imported from a vendor. They created that data type in...