Ranking columns

Question

Ranking columns

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

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

markjrouse Mr or Mrs. 500 Points: 512 More actions · Answer 1

"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

markjrouse Mr or Mrs. 500 Points: 512 More actions · Answer 2

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.

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 3

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!