Looking for a script to exclude duplicate records in a table.
I want the result to display only the single records, not the duplicated (account number) records in the table.
Additionally, I want to see if the account number records from another table, match the single (account numbers) records in the above table.
I have about 30 fields in the table w/duplicates
I am using SQL Server 2005.