Posted by Rich Ryan on 12/05/05 02:16

But you notice in this example the number of columns is fixed. Not what the
OP wanted.

Rich
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9722758F36C47Yazorman@127.0.0.1...
> --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]