No. It is not what I want.
This is a normal aggregation.
The sum function will be called once for each
group (SalespersonNm) and it will return one row.
What I have asked is : if I have 10 rows, can I return 12?
It's rude, but that's the idea.
Thanks,
Felix
DL Neil wrote:
Felix,
Is is it
The idea is simple:
I want to implement some temporal computation
on timeseries like normalization and interpolation
to smooth the data and fill the missing values.
So, for example if have a table like that:
starttime,endtime,counter
12:00,12:30,34
13:00,14:00,25
you see that for 12:00 the
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Felix LUNGU
Sent: Thursday, December 05, 2002 12:27 AM
To: Victor Pendleton; [EMAIL PROTECTED]
Subject: Re: Aggregating function which returns more than one row
The idea is simple:
I want to implement
Felix,
Is is it possible to write an aggregation function which returns
more than one row?
Yes - if I have understood your requirement correctly.
It would have been helpful if you had given some idea of the
application/what you want to achieve. Here's an example from out of my
imagination: