Post reply

Ranking columns

  • March 30, 2010 at 7:14 am

    #1142173

    "Mark says that if there is match between the values present in the columns, then he asks us to look at one priority table which will tel us which column must be the top priority in the matching columns and use that column accordingly.."

    Spot on

    I can get the case statement to work, its just updating the result based on the prioroty criteria. thanks

  • March 30, 2010 at 7:24 am

    #1142187

    Hi Lowell,

    I must have copied it incorrectly, but it does work. I recopied and pasted the code and modified it to match my column names and it seems to work.

    Thanks for this.

  • March 30, 2010 at 9:05 am

    #1142316

    markjrouse (3/30/2010)

    Hi SSC-Enthusiastic,

    Mate, i guess u got my name wrong..i am ColdCoffee and SSC-Enthusiastic is the category what SqlServerCentral.com has assigned me to..

    and for the function, it worked as ur expected results in your previous post.. can u pls try to copy the full table and the function correctly mate?

    i worked perfect for me and i even had a peer-review done on my code..

    Please ping me back/PM me if u have any doubts on that function..

    Cheers,

    C'est Pras!

Viewing 3 posts - 16 through 17 (of 17 total)

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