Hi, good improvement in relation to 1rst part of the series, now the procedure receives only one parameter and filling the tables is now equal on the header and the items. If I had more child tags inside Items (say bunch of subitems) then I had to use something like:
FROM OPENXML ( @hdoc, '/salesOrder/lineItems/item/subitem', 1 ) WITH (
subItemNumber VARCHAR(20) '@subitemNumber',
subQty INT '@subqty',
subRate FLOAT '@subrate'
) AS x
And last but not least. Same problem when trying to download the sql code, the links are empty.