Post reply

DECODE and DISTINCTROW

  • April 30, 2004 at 11:55 am

    #162417

    Hi everybody,

    is there any equivalent keywords in TSQL to these, functions one in ORACLE:

    1)DECODE

    2)DISTINCTROW

    ??

    thanks a million

     

  • May 1, 2004 at 6:15 am

    #504927

    Use CASE as a substitute for DECODE.  Of course, "equivalent keywords" usually are not "equivalent" and will require a bit of rework.

    Don't know what DISTINCTROW is... and don't want to throw you by guessing.  Wazit do?

     

    --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)
    Intro to Tally Tables and Functions

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

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