Development tables

[Claire]

Hi,

I have a few tables that was created without primary keys for development
purposes. Currently, I need to export the tables to production database but
need to perform some cleanup on the duplicate rows.

Is there a way to select "just" the duplicate rows using transact SQL?


Thanks.

[Mark]

Claire,
I always forget what the code is to do this so I cheat. Access will create
a query to check for dups using a wizard. I then copy the SQL and modify
as needed.

Mark

"Claire" <cheerio74@excite.com> wrote:
>
>Hi,
>
>I have a few tables that was created without primary keys for development
>purposes. Currently, I need to export the tables to production database
but
>need to perform some cleanup on the duplicate rows.
>
>Is there a way to select "just" the duplicate rows using transact SQL?

>
>
>Thanks.

[Claire]

Does anyone know if it can be applied to SQL2000?

"Mark" <mknuttall@nospam.yahoo.com> wrote:
>
>Claire,
> I always forget what the code is to do this so I cheat. Access will create
>a query to check for dups using a wizard. I then copy the SQL and modify
>as needed.
>
>Mark
>
>"Claire" <cheerio74@excite.com> wrote:
>>
>>Hi,
>>
>>I have a few tables that was created without primary keys for development
>>purposes. Currently, I need to export the tables to production database
>but
>>need to perform some cleanup on the duplicate rows.
>>
>>Is there a way to select "just" the duplicate rows using transact SQL?

>
>>
>>
>>Thanks.
>

[DaveSatz]

this may help: http://www.mssqlserver.com/faq/development-duprows.asp
--
HTH,
David Satz
Principal Software Engineer
Hyperion Solutions
->Using SQL Server 7.0 SP3/6.5 SP5a/Cold Fusion 4.5.1 SP2/VSS
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------
"Claire" <cheerio74@excite.com> wrote in message
news:3aaf5878$1@news.devx.com...
>
> Hi,
>
> I have a few tables that was created without primary keys for development
> purposes. Currently, I need to export the tables to production database
but
> need to perform some cleanup on the duplicate rows.
>
> Is there a way to select "just" the duplicate rows using transact SQL?
>
>
> Thanks.

[DaveSatz]

or http://support.microsoft.com/support.../q139/4/44.asp

"DaveSatz" <davidsatz@yahoo.com> wrote in message
news:3aaf7af3$1@news.devx.com...
> this may help: http://www.mssqlserver.com/faq/development-duprows.asp
> --
> HTH,
> David Satz
> Principal Software Engineer
> Hyperion Solutions
> ->Using SQL Server 7.0 SP3/6.5 SP5a/Cold Fusion 4.5.1 SP2/VSS
> (Please reply to group only - emails answered rarely)
> -----------------------------------------------------------------
> "Claire" <cheerio74@excite.com> wrote in message
> news:3aaf5878$1@news.devx.com...
> >
> > Hi,
> >
> > I have a few tables that was created without primary keys for
development
> > purposes. Currently, I need to export the tables to production database
> but
> > need to perform some cleanup on the duplicate rows.
> >
> > Is there a way to select "just" the duplicate rows using transact SQL?
> >
> >
> > Thanks.
>
>