Thanks, I am going to dissect that query to figure out why it works. Sorry for the rookie post when I started this thread. I will do better on my...

I understand your concern with that but the columns that I truly need for the summations do not change when one duplicate record is deleted. Is it more efficient in...

Thank you sir.

I want all the records in the table for those distinct records. Here is the query that I tried to run but only received duplicates again.

select distinct...

I hope i can redeem myself with this final post and hopefully find a solution to this query.

Here is my code reworked and now the create table works fine and...

Ahhhhh - you are correct sir. Sorry I missed that. I need to add an INT column then to make a unique identifier for this then? If so, how would...

Also I will be running this query on a monthly basis for a report. I wanted to start with this and see how I could achieve unique data first.

Im trying to get 2005 but the expense is a little high for me. I want to make it a concatenated PK with ClientNumber and ClientAcctNumber for the TMP9999 table....

Attempt number two for you my friend. Hope this works.

CREATE TABLE tmp9999

(

ClientNumber VARCHAR(10) null,

ClientAcctNumber VARCHAR(20) null,

Period VARCHAR (8) null,

FinancialClass VARCHAR(10) null,

Listdate DATETIME(8) null,

InitialBalance MONEY(8) null,

CurrentBalance MONEY(8) null,

PaymentDate DATETIME(8) null,

PayType VARCHAR(12)...

I create all my tables in Enterprise Manager. I dont use scripts for those thats probably why the one I posted is wrong.

Sorry about all the confusion. It doesn't matter which of the dups I keep because the fields I need to sum on are the same in both records.

I am going to have to do some sums of the balances and and total accounts later on and do not need to count duplicate records. For instance I will...

Thats where I thought I could use Distinct to determine to keep only one of those records. For the process I am currently working on I only need one. So...

CREATE TABLE tmp9999

(

ClientNumber VARCHAR

ClientAcctNumber VARCHAR

...

Sorry about that first time here. Give me a few minutes and Ill have that information up.