If I remove the 2 foregin keys (FK__CallHisto__Accou__45344BC4)
(FK__CallHisto__Charg__471C9436) that are presently on CallsHistory, then
Delete the duplicate records, can I successfully add the 2 keys back??????
> > 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