Hi vish

u have not mentioned which version of sql server u r using because if u are using sql server 2000 then u will not be able to use Delete top clause.