Home Forums SQL Server 2005 Development Delete Duplicates from table with no identity column RE: Delete Duplicates from table with no identity column

  • September 25, 2009 at 10:13 am

    #1058553

    ar-727381 (9/25/2009)

    i already have this table created. i just gave you the top few rows of it. I dont think i can update the table with %%LockRes%%

    so will need some more help to achieve deletion of duplicates.

    by the way. it was nice to know about the hidden feature. thanks a lot

    ALL tables, including the one you created, have this....it's just hidden:

    try SELECT %%LockRes%%,* FROM YOURTABLE

    you'll see it exists, and so you could adapt our example solutions to do the same.

    jghali 's solution is so clean and simple, I would highly recommend it...just change the group columns to your real columns.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!