Hi Senthil,

        I can tell you that u can 1st take the full back up and then take the differential back up based on the day or weeks..

 Full backups...

Hi Senthil,

      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...

Hi George,

     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...