Saturday, 18 October 2014

XML master / detail SQL



I'm trying to generate the xml below from sql 2012 tables. between dashes there is a details section.



<?xml version="1.0" encoding="ISO-8859-9"?>
<MATERIAL_SLIPS>
<SLIP DBOP="INS" >
<GROUP>3</GROUP>
<TYPE>50</TYPE>
<NUMBER>SF0031</NUMBER>
<TRANSACTIONS>
-------------------------------------------------
<TRANSACTION>
<ITEM_CODE>SP.01.0Z00</ITEM_CODE>
<LINE_TYPE>0</LINE_TYPE>
<LINE_NUMBER>56</LINE_NUMBER>
<QUANTITY>309</QUANTITY>
</TRANSACTION>
<TRANSACTION>
<ITEM_CODE>ZL.01.0500</ITEM_CODE>
<LINE_TYPE>0</LINE_TYPE>
<LINE_NUMBER>57</LINE_NUMBER>
<QUANTITY>56</QUANTITY>
</TRANSACTION>
<TRANSACTION>
<ITEM_CODE>ZL.03.0800</ITEM_CODE>
<LINE_TYPE>0</LINE_TYPE>
<LINE_NUMBER>58</LINE_NUMBER>
<QUANTITY>4</QUANTITY>
</TRANSACTION>
---------------------------------------------------
</TRANSACTIONS>
</SLIP>
</MATERIAL_SLIPS>


any help appreciated. thanks.


No comments:

Post a Comment