Sales Order Workshop Part II

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Jacob Sebastian » Sales Order Workshop Part II

Sales Order Workshop Part II

Rate Topic

Display Mode

Topic Options

Author

Message

jacob sebastian

Posted Monday, March 12, 2007 9:27 AM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:17 AM
Points: 460, Visits: 2,521

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

.

Post #350764

charles-504039

Posted Wednesday, February 25, 2009 7:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 30, 2009 1:02 PM
Points: 1, Visits: 27

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

jacob sebastian

Posted Wednesday, February 25, 2009 10:25 AM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:17 AM
Points: 460, Visits: 2,521

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

yazalpizar_

Posted Wednesday, December 21, 2011 12:59 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:38 PM
Points: 139, Visits: 292

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 »

Permissions