Post reply

Sales Order Workshop Part III

  • March 12, 2007 at 9:59 am

    #119178

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

    .

  • April 9, 2007 at 10:32 pm

    #699440

    If you say A you have to say and B .

    Please can you explane how to save data from an windows master/ detailed form in XML format.

    Excuse me, I am new in XML

     

  • April 13, 2007 at 4:18 am

    #700301

    could you give me a more precise problem description? i will get back to you with a working example then.

    .

  • February 13, 2008 at 5:02 am

    #777752

    Hi Jacob,

    In the Sproc SaveSalesOrderIII, if I put the OrderHeader details obtained from OPENXML into a temp table/table variable and update the orderheader table by joining with that.Which one will be better,either using XML or just query once and join that output later on? This way we can avoid using OPENXML. Does it make any difference?

  • March 29, 2008 at 12:31 am

    #795574

    If you need to join with the results of OPENXML in more than one query/batch, it is advisable to put the results of OPENXML into a memory/temp table and use it.

    .

  • December 22, 2011 at 9:00 am

    #1424840

    Great, just tested, everything ok, had some collation issues on my database but is ok now.

    I received several "invalid name error" related to ItemNumber/itemNumber, OrderNumber/orderNumber, OrderHeader/orderHeader. Don't know exactly if it is my fault or it is related with the collation errors I was having.

    As before, the links to the source code are empty.

    So far, so good...

Viewing 6 posts - 1 through 5 (of 5 total)

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