Sachin Vaidya (2/14/2013)
Hi Cadavre,Your response definitely shows a path to move ahead, thanks a lot for that.
But on the other side, it was very rude. It will discourage people from putting any questions to the forum.
To underline, this was not my tution assignment or homework which I wanted to get done from the forum (read spoonfeeding).
To create an example, I suggested RankID as 3 and 4 but it is not limited, RankID's can be in thousands, so I will not be writing thousand CASE staements...
What sounds like a cakewalk to you might be a bit 'tricky' for others, as all fingers are not same!
But in the end, I would like to appreciate your effort spent in posting a detailed reply.
Thanks and Regards.
I know that you have subsequently apologised, but this message is out of order. If you need someone to do your work, hire a consultant. We are unpaid volunteers who help out when we can.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.