Post reply

RECURSIVE SELECT PARADOX!

  • August 11, 2006 at 8:48 am

    #654578

    Can you post an example of how you want your data to look?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • August 11, 2006 at 9:28 am

    #654596

    I want to show modified column with its original value.That's all..

    For example there are some modified values which belong to same OrderID. I want to combine two results into one row

  • August 11, 2006 at 9:40 am

    #654601

    I am still not clear on what you need.  I see that you have added Before and After to your column list in your new SELECT.  Can you post an example of how you want your new results to look like just as you did with your 'simple' select?  Are you just wanting to get a different result set back from your History_OrdersTable table?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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