unordained wrote:

> Is there an aggregate function that multiplies all non-null values to provide a result?

No...

> If not, is
> it possible to write aggregate functions as UDF's?

Not really. UDF's work on a single set of inputs - they can't accept
input record streams.

> This would be
> to use in a select with group-by, to find total ratios for several items at once, based on the
> product of component ratios.
>

You're probably going to have to put the whole operation in a stored
procedure.

Regards,


Ann