Post reply

SQL SERVER 2000

  • March 14, 2011 at 12:40 am

    #144906

    Hullo Friends,

    I am encounter problem trying to retrieve the Maximum SalesOrderID from the TblSales. The maximum value of it is 10912 . The Sql String that I created is not working.

    This is the last record with the Highest OrderID value 10912/

    My sql string produced 11097 value instead of 10912.

    Here is the Sql String coding:

    Select MAX(SalesOrderID) from TblSales

    I need your help, please help me. Thank you.

    Have a Good Day,

    Cheers,

    Lennie

  • March 14, 2011 at 12:52 am

    #1298199

    what result do you get from:

    SELECT top 1 SalesOrderID from yourtable

    ORDER by SalesOrderID DESC

    ??

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 2 posts - 1 through 1 (of 1 total)

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