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

[Back to original message]