You are here: Re: dynamically trasnpose rows into columns « MsSQL Server « IT news, forums, messages
Re: dynamically trasnpose rows into columns

Posted by --CELKO-- on 12/22/05 05:07

The length of the post is fine, but this sounds like a weird way to do
business! The closest thing I can think of is a concatenation (or
"shop tag") code that keeps getting longer as a piece moves from
station to station. I have seen two serial numbers due to a merger and
two inventory systems, but not anything like seven of them!

My first attempt would be to have a table with seven columns that looks
like the report you gave. Adding a board id of your own begs the
question as to what all these other things mean in terms of a data
model.

This might be more than we can do in a Newsgroup.

 

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

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