question

Chris 2 avatar image
Chris 2 asked

MS SQL 2012 t-sql to xml

Hi, MS SQL 2012/Windows2008R@. How do I convert following XML format: Employment Status Mapping ROLE Contingent WorkerEmployeeContructorVendor to: Employment Status Mapping ROLE Contingent Worker Employee Contructor Vendor Thanks
mssql2012
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@Chris 2 In the source XML, you have a value **Contingent WorkerEmployeeContructorVendor**. Because there is no delimiter, it is not possible to figure out the rule to use to split this single value. Do you know what rule should be used? For example, it could be something like this: there is a predefined list of words, which can be bunched up together in the source XML and need to be split. The combined words which make up the combined value are never outside of that predefined list. Please clarify. Once the rule is defined, converting one shape to another will be a trivial task, though it is worth mentioning that such tasks are best when done outside of the database.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.