You are here: Re: Return subquery rows as one delimited column « MsSQL Server « IT news, forums, messages
Re: Return subquery rows as one delimited column

Posted by kingskippus on 10/28/06 18:54

--CELKO-- wrote:
> Why do
> you wish to destroy First Normal Form (1NF) with a concatendated list
> structure? It is the foundation of RDBMS, after all.

Maybe, but what I need is a column that returns a string that is a list
of items in a separate view. The goal is to make things easy on the
end users of the data. If they want to iterate over the list of items
and customize the way it's presented, they can. If they just need a
quick list of the items, they can get that, too.

Sometimes there is an ideal way to do things assuming that your users
have the same tools you do at their disposal, and a real-world way
where you have to answer to the demands of what your users really want.
;-)

 

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

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