Re: update table a.fkid from table b.pkid, additional information

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 14 Jul 2004 18:18:57 -0700
Message-ID: <1089854355.787258@yasure>

amwi wrote:
> Forgot to mention:
>
> I use Oracle 10.1 and SQL *plus 10.1.
>
> Thanks for your help!
>
> "amwi" <amwi_at_yahoo.com> wrote in message
> news:DzaJc.98539$dP1.331950_at_newsc.telia.net...
>

>>I have tried to solve this on my own for a long time now, so i really need
>>som help here...
>>
>>How do i update table a.fkid from table b.pkid with the following "rule".
>>The table b.pkid's should be evenly distributed over table a.fkid's.
>>
>>Does anyone have a tip on how to solve this?
>>Thank you.

I hope you don't think that what you are asking is at all clear because it isn't.

What is your definition of "evenly distributed"?

Does this include randomization?

In the end you'll likely end up with some form of stored procedure.

Daniel Morgan Received on Wed Jul 14 2004 - 20:18:57 CDT