Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DISTINCT COPY of data

Author  Topic 

Johnyalm
Starting Member

49 Posts

Posted - 2001-03-11 : 02:11:42
I have a temporary table with 8 columns. I the table there is a lot of doubled rows according to one of the fields (email field). Thats because I am up to moving text file data to a SQL dbs. I would like to move the data DISTINCT from the temporary table to a costumers table. I would like to have ALL data from the first row for each email address to be moved from the temporary to the customers table.

I have not found any way to do this, but I am a newbie :-)

Please help me.

Johny Alm
www.mirrorgate.com

   

- Advertisement -