You are here: Re: Getting data from multiple rows into one column « MsSQL Server « IT news, forums, messages
Re: Getting data from multiple rows into one column

Posted by Erland Sommarskog on 12/04/05 12:35

--CELKO-- (jcelko212@earthlink.net) writes:
> Could you explain why you want to violate
>
> 1) The foundation of RDBMS, First Normal Form?

Because that is the way the user wants to see the data. You know plain
users does not give a dim wit about first normal forms. For them a
presentation like:

A: 2, 1, 2, 3
B: 3, 4, 5, 3

is probably a very normal form to them.

> 2) The most basic rule of a tiered architecture?

While this is best done client-side with SQL 2000, I don't think this is
something which is very well supported with report writers. And not all
clients are even that sophisticated. Many reports are run from Query
Analyzer or a similar tool with no formatting capabilities at all. Thus,
any formatting has to be done in the RBDMS.

> If you have a solid reason, woudl you mind publishing it, since that
> would overturn 30+ yers of RDBMS and 40+ years of Comp Sci.

Incidently, I have told you this several times before. So why do you keep
asking questions, when you do not listen to the answers?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 

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

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