i have one table. at the time of transactions some duplications are inserting in the database.
i want to delete duplications but not distinct rows. Means i want only distnict rows in the database.
how it is possible using sql server7.0.
i have one idea. At first i want to create a Alias of particular table. i will shift rows to the alias table. after that i will delete origional.
is it works???
if you find answer about this please.... reply.
thank you advancedly