You are here: Re: Query help needed « MsSQL Server « IT news, forums, messages
Re: Query help needed

Posted by othellomy on 03/15/07 10:12

On Mar 14, 9:24 pm, seph...@gmail.com wrote:

> I'm not sure what avenues to try next. Any suggestions?

You might try to create a temp table with all the column names you
desire (FolderCode ParentID... etc). Fill the table making sure you
only join with one or two tables at a time. Each time you check the
result. If you don't like it then reduce the number of tables in your
join. You keep joining with other tables and fill your temp table. If
this does not make sense then post DDL of all tables with some sample
data and we can take a crack at it.

 

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

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