Re: SQL Problem

Sometimes you just have to make a choice and live with it. If you can get a manager to say which way to default the situation, then hopefully this will get most of the records back in line. Is it possible that the side effects are minimal by choosing one part of the overlap over another? (e.g. if seniority is company wide, then which store was employee located in has no impact. But if it's store-based for some benefits, then there are consequences to resolve.)

Not everyone has the luxury of sending the data back to get cleaned up. Lucky you!

Niall Litchfield wrote:
>
> "D R Patterson" <patterd1_at_home.com> wrote in message
> news:3BB98670.82EA1C47_at_home.com...
> > Niall,
> <snip>
>
> > The manual effort to figure out what is to be done will be tricky, but
> that is
> > true no matter what method was used to highlight the people with
> questionble
> > data.
>
> too true. Fortunately that job goes back to the data inputters who got it
> wrong in the first place, There is no real way of deciding what the correct
> data is other than by knowing what actually happened.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
Received on Fri Oct 05 2001 - 21:59:44 CDT