SQL

I have a Form which is based on a procedure. The procedure has a cursor which looks something like this

Select resource_type, task_code, sum(qty_1) from recordings
where project_id = 1
group by resource_type, task_code;

The resulting cursor would look something like this Resource_Type Task_code sum(qty_1)

L                        20010           100
P                        20010            200
C                        20010            300
L                        30020            100
P                        30020            200
L                        40030            100

I want the output to be displayed in forms something like this

Task                    L
C                            P
20010                 100                    300
200
30020                 100


-                             200

40030                 100


-                             -

Basically I need to manipulate the cursor output. Is it possible to do. The number of task_codes selected can vary depending on the records. Right now I actually select all the task_codes for the selected project and find the qty individually for every task and resource_type. This seems to be very slow. Any suggestions

Thanx...kasi Received on Tue Apr 11 2000 - 03:03:45 CEST