You are here: Re: Maintaining a chain with multiple inserts « MsSQL Server « IT news, forums, messages
Re: Maintaining a chain with multiple inserts

Posted by Thomas R. Hummel on 10/01/05 17:38

John Bell wrote:
> Hi Thomas
>
> This gives you the results you wanted, but if you have more than one chain
> you will need a means of identifying them.

Unfortunately, that's perhaps the biggest problem that I have. The only
way to determine that a row in Copy_To or Copy_From is in a chain with
another row is to follow the links. Once the rows are in the Chain
table the Orig_ID can be used to distinguish all chains.

I'll play around with the code that you included and see if I can get
something worked out. Unfortunately, I think that I'm going to be stuck
recursing through the chains to link them together.

Thanks for all of your help!

-Tom.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация