>> Right, the aggregate messes things up ;-)
>>
>> Have you ever looked at SELECTable Stored Procedures? Those
>> allow you to pass parameters.
>>
> Selectable procedures work, but processing their output is expensive in
> terms of computing power (e.g. SELECT ... FROM someprocedure(...) ORDER
> BY a, b, c). Those nested queries are a better option.

Yes, alternatively, you can put all ORDER BYs and so on in the procedure,
that makes them a lot better.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com