Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David McKinney Linking to the Previous Row RE: Linking to the Previous Row

  • March 13, 2008 at 8:42 am

    #789102

    jordonpilling (3/13/2008)

    a very nice article indeed, however i recently had the same issue on SQL Server 8.0, Is their a related atricle/method for SQL 8?

    You should be able to do the same thing by making the PriceCompare a temporary table with an identity column instead of the ROW_NUMBER() for rownum.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers