Re: get some rows into one column
- From: --CELKO-- <jcelko212@xxxxxxxxxxxxx>
- Date: Wed, 31 Oct 2007 10:57:44 -0700
There are a lot of good reasons so many experienced SQL programmers
are warning you about this.
Why do you wish to destroy First Normal Form (1NF) with a concatenated
list structure? Normal forms are the foundation of RDBMS, after
all.
Why are you formatting data in the back end? The basic principle of a
tiered architecture is that display is done in the front end and never
in the back end. This is a more basic programming principle than just
SQL and RDBMS.
Get a reporting tool so you can do a sort for your lists and lay them
out on paper or a screen in a way that a human being can read them.
The kludges that have been posted are unpredictable, unsupported and
some are highly proprietary.
.
- Follow-Ups:
- Re: get some rows into one column
- From: Tony Rogerson
- Re: get some rows into one column
- References:
- get some rows into one column
- From: candide_sh
- get some rows into one column
- Prev by Date: Re: get some rows into one column
- Next by Date: Re: some error in table definition
- Previous by thread: Re: get some rows into one column
- Next by thread: Re: get some rows into one column
- Index(es):
Relevant Pages
|
