SQL

From: <kskasi_at_hotmail.com>
Date: 2000/04/13
Message-ID: <38F50A09.9D99184A@hotmail.com>#1/1

Hi everyone

I have an SQL which looks like the following

Select resource_type, task_code, sum(qty) from recordings
group by resource_type, task_code;

The result set looks like the following
L 20010 1
L 30010 2
L 40010 3
P 20010 4
P 30010 5
P 40010 6

I want the output to be displayed in the following format

                L        P
20010    1        4
30010    2        5
40010    3        6

Is it possible to so. I need to do that inside a cursor

regards...kasi Received on Thu Apr 13 2000 - 00:00:00 CDT