Home Forums SQL Server 2008 T-SQL (SS2K8) Order by a column keeping the families together RE: Order by a column keeping the families together

  • September 6, 2012 at 9:35 am

    #1534572

    CELKO (9/6/2012)

    SELECT CONVALESCE (upc, family_upc) AS item_upc, purchase_date

    FROM Inventory

    ORDER BY item_upc, purchase_date;

    CONVALESCE? I can't find these on any SQL books, just medicine.

    The design is poor? it might be but it's not the actual design, just an example to ask for help.

    Your solution won't work because it's not what the OP needs.

    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