How to delete duplicate record in sql server without using procedure and cursor?

If you can't write a procedure to detect and delete duplicate data then your only other option is to prevent the data from being duplicated in the first place. Try using the number field as a unique field in your table. That should prevent the duplicate records from being written.