access to "COMPUTE" aggregate function?

[lifeinkorea]

Came across an interesting article about the COMPUTE option in TRANSACT-SQL.
The example given was the following:
SELECT
Prod.ProductId ,
Prod.ProductName ,
Cat.CategoryName ,
Prod.UnitsInStock * Prod.UnitPrice AS StockValue
FROM dbo.Products AS Prod
INNER JOIN dbo.Categories AS Cat
ON Prod.CategoryId = Cat.CategoryId
ORDER BY
Cat.CategoryName
COMPUTE SUM(Prod.UnitsInStock * Prod.UnitPrice)

The results actually return 2 record sets- the first being as expected and the
second being 1 row consisting of the sum. However, if you run it in CF, you
only seem to have access to the first recordset. Is there anyway to access the
second recordset?

[paross1]

Put your T-SQL into a stored procedure and called it with CFSTOREDPROC, then you can retrieve both results sets with CFPROCRESULT tags.

Phil

[lifeinkorea]

Cool- works as advertised! Thanks!!