I can use Visual Studio/Interdev to delete the individual rows.. just did
not know if that would affect anything else if I manually deleted them...
So if it doesn't, Then I need to figure out what row a duplicate is on then
just delete the duplicates????
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Wednesday, February 17, 1999 2:30 PM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] consolidation errors - update #1
>
>
> "Ronnie D. Franklin" wrote:
> >
> > AccountID StartDate Months
> > ----------- --------------------------- -----------
> > 39 Feb 28 1999 12:00AM 1
> > 40 Feb 28 1999 12:00AM 1
>
> > Now.. do I just go find each one of those and delete the row in
> > CallHistory??????
>
> Do a:
>
> Select * From CallHistory
> Where AccountID=40 and StartDate = '2/28/99'
>
> and see if there is anything unique about them (maybe minutes and
> calls).
> Then you can delete one of them based on then unique criteria. If they
> are exactly the same, the only way I know to delete one of the two is
> using a cursor.
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html