Pivot Data

I have data in this format

Product qty
ABC 4
DEF 5
:
:
XYZ 4


I'll never have more that 10 products at a time.
I need to deliver the data in a format like this:

prod_1 qty1 prod_2 qty2 ... prod_10 qty10
ABC 4 DEF 5 XYZ 4



If there are less than 10 products, the last columns will contain NULL.
What I'm doing is delivering a recordset to a report.
The report is designed to work with a single record, not multiple lines.
Of course, there's more data than this, this is just where I'm stuck.

Is there a way to pivot this data? I'm using SQL2000

Here's a ddl of what I've been trying to work with,
but all attempts at pivoting have been = FAIL

CREATE TABLE #TMP (
PKG_CODE VARCHAR(20),
QTY_ACT INTEGER)

INSERT INTO #TMP
SELECT 'PAD', 15
UNION ALL
SELECT 'PAD4436', 15
UNION ALL
SELECT 'SW', 15
UNION ALL
SELECT 'TS', 16

SELECT * FROM #TMP

DROP TABLE #TMP