Home Forums SQL Server 2008 SQL Server 2008 - General SQL Beginner RE: SQL Beginner

  • August 26, 2012 at 8:30 am

    #1530113

    shikhar_0511 (8/25/2012)

    hey sorry forgot to mention this before

    arizona alabama 788 is also there in original data

    But lets say there is

    arizona alabama 0 i.e tonnage value=0

    data also there

    so what i want is not to show this data in the output

    ie. if there is no tonnage value in the return direction then output table should not have such values

    Also

    the original table is randomly arranged with the data

    what i want is the output to be only in this format

    Arizona Alabama 788

    Alabama Arizona 34

    ie. consecutively arranged in this way.

    I've worked with truck shipments and other delivery logistics/tracking before. You really need a truck number and a delivery date in the data. Do you have those in the data? If not, this project is pretty much dead because you'll never be able to correlate and sort the data properly.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)