locked
Xquery in MS SQL RRS feed

  • Question

  • User1124534712 posted

    Dear friends,

    I have to compare two XML node that node not available i need to insert in XML dynamically .kindly help .sample belo

    DECLARE @Pdata XML
    DECLARE @COmData XML

    SET @Pdata='<URS>
    <DR CN="DefRate" ST="1" RM="">10.00</DR>
    </URS>'

    SET @COmData='<URS>
    <DR CN="DefRate" ST="1" RM="">10.00</DR>
    <SR CN="DefRate" ST="1" RM="">10.00</SR>
    </URS>'

    Saturday, February 29, 2020 10:33 AM

All replies

  • User1535942433 posted

    Hi inbaa,

    Accroding to your description, I don't understand your requirment clearly.

    Could you tell us more details about how and what to compare? What do you decide to do?

    Besides,I suggest you could post sample data for the result you wants.It will help us solve your problem.

    Best regards,

    Yijing Sun

    Monday, March 2, 2020 7:06 AM