Posted by Doug on 12/16/05 20:27

Celko??? Perhaps you might have some insight?

The gentleman has correctly stored his data in relatively, for purposes
of this discussion, normalized form.
Now, he wants to present it in human readable form using standard,
simple, SQL select commands.

Mr. BIhn, you might look into Pivot tables in Excel. Drag your card
thingy record on the left side, and the non-unique serial numbers
across the top right.

Towards the mononamed CELKO (not to be confused with the artist
FORMERLY known as Prince,) Fundamentally, SQL does not solve this
problem, and you will have to resort to kludges in order to solve this
fundamental, yet oh so common business need.
Or, do what the old timers did, and tell the users they really don't
need this information, they just think they do.

[Back to original message]