Home Forums SQL Server 2005 T-SQL (SS2K5) Most efficient way of finding and storing where there are duplicate entries RE: Most efficient way of finding and storing where there are duplicate entries

  • Hi Jeff

    For now I was just wanting a list of the duplicates. I'm learning its mostly a matter of preference whether we use the GROUP BY or WITH statements or maybe a different solution. I'm not really at the Developer level yet where I have to know the database really well - I currently work in IT Support so just writing little custom scripts at the moment to help customers as a workaround to help them until a Developer can look into (if ever).

    Cheers

    James