This may not sound elegant, but a two step approach is to query out the entire xml string with the Results To File setting selected. Save the results to a...

The...

Briceston (11/1/2016)

---

Thank you for your insight. Your example was not exactly what i needed to answer my question, mainly due to a new Id is issued for a readmission. ...

Does this help ?

DECLARE @tbl TABLE

(

id INT,

col XML

)

INSERT INTO @tbl

VALUES

(1,'<name><name1>aht</name1></name>'),(2,'<name>6</name>')

select *

from @tbl

where col.value('(/name)[1]','varchar(10)')='aht'

Thanks Ed. No tricks, though it is the day after...

Below is a sample of the underlying data. Please excuse me if I did not use the correct code, and for the headers not being completely aligned.

Reporting YearReg AreaOrignalAdmissionOrignalDischargeReadmissiondischargedatedays between...

Hello, our server hard disk crashed due to power failure and all the backups were on the hard disk. Before just before it did we had managed to copy the...

Lynn Pettis (10/28/2016)

---

Chris Wooding (10/27/2016)

---

Just as an aside; I have got into the habit of using the "Script as create" instead of "Script as alter" or "Modify" options when looking...

Depending on who you ask, if you go around the company eventually you might find most all of it...

And for any outside service that does cleansing, just be mindful about any protected information in your agreements from which you get these addresses. I see no issue with standardizing...

I DID NOT say "Users are entering data", what I said was "We get tables" - meaning these are tables exported from other systems where the limits are not...

As for ongoing maintenance, there is a fancy cliche out there ... something like "machine learning." It means that new codes that are not familiar would get captured by the...

Maybe this helps? It may not look pretty, but it it worked for me given your requirements of removing the final suffix if it is directional and standardizing the street...

Just one item of consideration that I wanted to throw out there. The bookings can change from day to day, since from a business perspective I imagine each booking can...

If you must have all in one row, you can opt for the names of the people on the project to be stored in a XML type column.