just now i checked ur prob. As u should run the query from 'begin tran' to 'Roll back' together.anyway if you have any duplicate once in of that table in any other...
Thanks for the mail. Actually i want to assign the Ranking function in SSRS. Not in T-SQL.But your Ranking logic in T-SQL is really efficient.Please give some suggettion in SSRS how i can...