Posted by serge on 06/06/05 01:19

> The difference from your reuslts table is that Product 4 now gets the
> name JKL2, and JKL is at Product 8. But since 4 and 8 are clones of
> each other, my guess is that it doesn't matter.

I am 99% sure it does not matter. I'll find out soon if it matters but I
doubt it.

I tried your code and it works great. I analyzed it for the last hour to
understand what you were doing. Now I understand and I didn't consider
before using a temporary table like you are using. I was planning on
using a cursor and loop through the records one by one which would have
been much slower than your approach. Not to mention it would have been
complicated also.

Next time I'll think about using temporary tables as I realize now how
much flexibility it gave you to do the gradual data manipulations.


Thanks a lot Erland, I appreciate your help.

• Next in forum: Another Newbie Question (about queries)
• Prev in forum: Re: Code in the database or middle tier (the CLR controversy)
• Thread view: Re: UPDATE/INSERT to make One-to-Many table become One-to-One

[Reply to this message]