Home Forums SQL Server 7,2000 T-SQL how to ignore null columns RE: how to ignore null columns

  • February 27, 2013 at 10:19 pm

    #1591862

    josetur12 (2/27/2013)

    I need to get the last value regardless of the actual date.

    I tried both solutions and both work.

    Thank you.

    You might also want to consider changing the structure of the table. The way it is, it'll be interesting when they come up with a 5th date.

    --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)