> 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.

Pepak