multi column aggregates?

Started by Creager, Robert Sover 24 years ago1 messagesgeneral
Jump to latest
#1Creager, Robert S
CreagRS@LOUISVILLE.STORTEK.COM

Wondering if it's possible to create multi column (but a constant number of
columns per function) aggregate functions? I'm looking to create a weighted
mean, which uses the sums and products... of 2 columns. I have the SQL
statements to do what I want, but a two column aggregate in this case would
seem to work well.

Robert Creager
Senior Software Engineer
Client Server Library
303.673.2365 V
303.661.5379 F
888.912.4458 P
StorageTek
INFORMATION made POWERFUL