Nested While loop in SQL Statement

  • Hi, I am attempting to build a filed from a nested while loop running on an XML file.


    The SQL is as follows:


    I can't see the right place to paste while loop as it relies on a count of an xml node for the number of loops to perform.


    Can anyone help please?



    The nested while loop is here:




    Cheers


    Dave

  • Good question, will someone help us?
    [ATTACH=JSON]{"data-align":"none","data-linktype":"1","data-linkurl":"https:\/\/www.avito.ru\/yaroslavl\/rezume\/seo-seo-spets-prodvigadminbezopas-tkontentmenedzh_700971357","data-size":"full","title":"!_TOP_5.png","data-attachmentid":1218595}[/ATTACH]
    [ATTACH=JSON]{"data-align":"none","data-linktype":"1","data-linkurl":"https:\/\/vk.com\/andrew76_yar","data-size":"full","title":"!_TOP_5.png","data-attachmentid":1218596}[/ATTACH]
    [ATTACH=JSON]{"data-align":"none","data-linktype":"1","data-linkurl":"https:\/\/yaroslavl.hh.ru\/resume\/4b136a27ff014625ed0039ed1f46524a744130","data-size":"full","title":"!_TOP_5.png","data-attachmentid":1218597}[/ATTACH]
    [ATTACH=JSON]{"data-align":"none","data-linktype":"1","data-linkurl":"http:\/\/byrealty.ru\/","data-size":"full","title":"!_TOP_5.png","data-attachmentid":1218598}[/ATTACH]
    [ATTACH=JSON]{"data-align":"none","data-linktype":"1","data-linkurl":"http:\/\/yarkrovmontage.ru\/","data-size":"full","title":"!_TOP_5.png","data-attachmentid":1218599}[/ATTACH]

    Images

    • !_TOP_5.png
    • !_TOP_5.png
    • !_TOP_5.png
    • !_TOP_5.png
    • !_TOP_5.png