Sales Order Workshop Part II

  • jacob sebastian

    SSChampion

    Points: 11812

    Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2909.asp

    .

  • cwindhausen

    SSC Rookie

    Points: 25

    Concerning Sales Order Workshop II at http://www.sqlservercentral.com/articles/Miscellaneous/2909/[/url]

    The second sample under the subsection "Sample Data" has variable names that are a little confusing, probably because they were cut-n-paste from the previous sample code.

    x.orderNumber, x.customerNumber, x.orderDate might more appropriately be named x.itemNumber, x.qty, x.rate to avoid confusion.

    Thanks for the great article.

    Charles

  • jacob sebastian

    SSChampion

    Points: 11812

    Hi Charles, Thank you for pointing this out. I have corrected it, however, it might take a few days before the new version will be published.

    Thanks

    Jacob

    .

  • yazalpizar_

    Ten Centuries

    Points: 1365

    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.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply