Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RIght outer join Problems
Message
From
21/12/2005 16:37:19
 
 
To
21/12/2005 16:14:48
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01079896
Message ID:
01080032
Views:
18
Fabio, Sergey

I used this SQL statement to create a temporary table which I could delete the duplicate records from.

select lis_vol.*,identity(int,1,1) as UID into test3 from lis_vol order by township, range, section, stand

Thanks for all of your timely help.
Previous
Reply
Map
View

Click here to load this message in the networking platform