and yes I Get the error There is already an object named 'eapgdx' in the database.

If the table is not created, will it create a temp table or a permanent...

Sean, you had actually helped me out with the original query in another post,

I need to transform the data from one table

from

ICN|Sequence #|DX CODE

123| 01 ...

Yep thanks sean,

I used the max for all of the columns...did exactly what I needed it to.

but one question, do I need to create a temp table to make it...

That article gave me a start but I dont need to sum any data,

I just need to display it in the fashion above. no calculations

maybe i didnt read the...

Dwain,

I noticed the problem when I did a

select distinct icn count.

my total came to 264500

when I ran this query, I got 264461 total results. I went back...

The table has 4 columns

ICN, From Date of service, To date of service, and detail status code

123,1/1/12 ...