Post reply

SQL is burping

  • September 13, 2006 at 9:52 am

    #153182

    No other way to describe this, I have three columns, A, B and C, C = A/B, A = 4, B = 4, C = 0, the thing is that in all other cases in this table, the calculation is working fine, any suggestions as to why this one row of data is screwed up?

     

    UPDATE

    Never mind, user error, found the source calculation, it's set that if column B < 6 then C = 0.

  • September 13, 2006 at 10:00 am

    #660146

    thanks for the update - else folks may have spent hours trying to get to the bottom of this one..







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 14, 2006 at 8:54 pm

    #660569

    Whew!  The number 6 would have really messed me up... I only have 5 fingers on each hand!

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

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

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