> -----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.
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
> For more information about this list, including removal,
> please see http://www.iea-software.com/maillist.html
>
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html