|
In my case the order isn't important. I just need a table layout thatlist
looks like the other table. That saves me from having to rewrite the
logic that reads through the records and populates the recordset that is
returned by the program.
I think I am getting close to solving this one.
Pete
lgoodbar@xxxxxxxxxxxxxx wrote:
I'm going through a similar issue with inhouse databases designed by our--
engineers. They designed the databases as they would be used in reports;
i.e. spreadsheet format with like columns going across. This limits
their functionality to the number of columns defined.
I want to redesign their database so that like data elements are stored
in their own table as rows. The issue/challenge is if they demand their
reporting queries remain the same, I must pivot the data in a view or
stored procedure. Even though the pivot (IMO) should be done by the
report, not the query.
Some of the data are like avg1, avg2, ... avg10; high1, ... high10.
These are columns in a table. As Chuck mentioned earlier, the challenge
is retrieving the data later so that the elements are "in order", avg1
before avg2 before avg10.
Loyd Goodbar
Business Systems
BorgWarner Shared Services
662-473-5713
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
No virus found in this incoming message.
Checked by AVG.
Version: 8.0.101 / Virus Database: 270.6.0/1602 - Release Date: 9-8-2008
13:22
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.