
October 15th, 2004, 08:32 AM
|
|
Registered User
|
|
Join Date: Oct 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Reading Data into Two dimensional array
I'm fairly new to SQL programming and this question may seem easy to answer. I have a SQL database that has four distinct columns.
1. A feature Number
2. A part serial Number
3. A measured value.
4. A Report Number
I"d like to read the data from the server for a specific report into a two dimensional array of measured values.
With distinct part serial numbers being the colums, feature numbers being the row identifier and the measured values being the actual data in the array or dataset.
serial#1 Serial#2 Serial#3
Feature#1 M.V. M.V. M.V.
Feature#2 M.V. M.V. M.V.
Feature#3 M.V. M.V. M.V.
The number of parts (serial numbers) may vary between reports as well as the number of Features.
Any help would be greatly appreciated.
|