Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. articles. downloads. faq. members. files. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: zakaria hamieh
  Where is zakaria hamieh?
 beirut
 Lebanon
 zakaria hamieh
Subject: RE: DELETE DUPLICATE
Thread ID: 186665 Message ID: 186670 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, July 30, 2008 11:21:28 AM         
   



> Hi all
>
> i have an sql 2005 database with stock table containing stock part and stock name
> i faced a duplication problem with this table
>
> how can i delete one of the duplicate and keep th other one
>
> b.regards
> zakaria
> foxes wil always be running

You could use union.

Cetin Basoz

ENTIRE THREAD

DELETE DUPLICATE Posted by zakaria hamieh @ 7/30/2008 10:44:24 AM
RE: DELETE DUPLICATE Posted by Cetin Basoz @ 7/30/2008 11:21:28 AM
RE: DELETE DUPLICATE Posted by Tom Saddul @ 7/30/2008 12:00:07 PM
RE: DELETE DUPLICATE Posted by Samir Ibrahim @ 7/30/2008 12:04:54 PM
RE: DELETE DUPLICATE Posted by Anders Altberg @ 7/30/2008 10:13:12 PM
RE: DELETE DUPLICATE Posted by Patrick McGreevy @ 8/3/2008 12:20:04 AM
RE: DELETE DUPLICATE Posted by Anders Altberg @ 8/3/2008 2:19:33 PM
RE: DELETE DUPLICATE Posted by Pete Sass @ 8/3/2008 1:30:43 AM
RE: DELETE DUPLICATE Posted by Anders Altberg @ 8/3/2008 2:33:30 PM
RE: DELETE DUPLICATE Posted by Pete Sass @ 8/5/2008 3:10:38 PM