Home Forums Data Warehousing Data Mining Need help on Sorting... RE: Need help on Sorting...

  • May 13, 2016 at 6:39 am

    #1878879

    viralbpandya (5/12/2016)

    I am not getting desired result for above.

    I want to sort the data first by "Planned Delivery Data" and than by "Order No".

    Use

    ORDER BY WES.CUSTOMER_ORDER_LINE.PLANNED_DELIVERY_DATE [ASC],

    WES.CUSTOMER_ORDER_LINE.ORDER_NO [ASC]

    If you convert dates to strings, it will follow string rules to order (2016-11 would come before 2016-2). The same will happen when converting numbers to strings.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2