Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sales Order Workshop Part II Expand / Collapse
Author
Message
Posted Monday, March 12, 2007 9:27 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jSebastian/2909.asp

.
Post #350764
Posted Wednesday, February 25, 2009 7:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 30, 2013 8:24 AM
Points: 1, Visits: 29
Concerning Sales Order Workshop II at http://www.sqlservercentral.com/articles/Miscellaneous/2909/

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
Post #664269
Posted Wednesday, February 25, 2009 10:25 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523
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


.
Post #664439
Posted Wednesday, December 21, 2011 12:59 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:18 AM
Points: 142, Visits: 432
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.
Post #1224936
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse