• ivor1994 - Monday, June 26, 2017 7:09 AM

    I think this solution will probably work properly so i will mark this as answer.
    I have only simple knowledge about XML so i will wait, learn more and than i will analyze this structure because for now it's black magic for me :D. Also it's too risky for use it in the large company database. Especially i'm not a SQL master. I'm using SQL only for read something and simple change.
    Thank you guys for your time.
    Eirikur Eiriksson. I think you solution will be useful for me in the future :).

    Storing XML as character data is a true SQL Server anti-pattern and should be avoided if possible, there are few penalties using that kind of methods and no benefits.
    😎