Re: [Emerald] consolidation errors - update #1

Dale E. Reed Jr. ( (no email) )
Wed, 17 Feb 1999 12:29:35 -0800

"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