Hi to all,
we use sapdb 7.4.
Is it possible to call a dbproc within a select statement.
Our app environment :
1. one table containing measurement data for different inspection lots
insp. lot | material | serial no | measurement no | measurement
result
1 4711 10 1 4.75
1 4711 10 2 4.79
1 4711 10 3 4.73
1 4711 10 4 4.75
1 4711 15 1 4.75
....
n
2. a second table which contains some common settings for each inspection
lot
Now we want to select several columns from the second table and all
measurement data grouped by serial number
Our result set should look like this :
inspection lot | date | inspector | ... | material | serialno | < a column
containing all measurement results as a concatenated string>
For now I can select all columns except the last one ( which is a dbproc )
Thanks
tom
