SQL Server 7
What I am trying to acomplish. I have some duplicate records that I need to
get rid of, the problem is that all these records already have a unique key,
but the rest of the fields are the same. I was hoping to be able to join two
fieldnames together and look for the duplicates that way..
For example... this is where I was headed...
Select from billing.first_name+ billing.last_name AS combined
HAVING COUNT( * ) > 1
It wouldn't work.... Any help would greatly be appreciated.
Jeff
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
