Sales Order Workshop Part II

• jacob sebastian

  SSChampion

  Points: 11822

  More actions

  March 12, 2007 at 9:27 am

  #153473

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

  .

• cwindhausen

  SSC Rookie

  Points: 25

  More actions

  February 25, 2009 at 7:59 am

  #949988

  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: 11822

  More actions

  February 25, 2009 at 10:25 am

  #950136

  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_

  Default port

  Points: 1425

  More actions

  December 21, 2011 at 12:59 am

  #1424066

  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.