Well, I'm not sure there's any specific guidance on this, but I have to wonder about a database design that fosters the creation of such a convoluted query...   Without considerably...

If there are consistencies in the method of that variable appearing, which at the moment appear to be:

1.) Starting delimiter = <
2.) Ending delimiter = >
3.)...

I don;t quite understand what you are trying to do.   Please post table create statements and inserts for sample data (not production data) that would be representative of what you...

It's that kind of thing that usually forces me into SSIS.  And at times, when even SSIS balks, back to VBScript.   Push comes to shove, an install of Excel on...

First, you have a primary key that doesn't have much of a natural use, so the question is, what about your data is unique to a given row?   I suspect...

Don't know exactly where it's stored, but I'm pretty sure it's in different places, depending on exactly which version of SSMS you are using.   Somewhere along the line, I recall...