|
|
-
Rodolfo Lassalle Commented 1 Years ago through Ask
Thank Sebastian, ican not use avg(duration), because ineed the total after sum all duration fieldvinseveral record belon to one kind of agent break. Iwill try the other two sugestions. I do not know about over().
Thanks...
|
-
Rodolfo Lassalle Posted 1 Years ago through Ask
Hi Sebastian, I need to add the values in the field Duration and I used Sum(Duration) which work well but if need to get the average. I tried AVG(Sum(Duration)), but I got an error, look like that SQL 2005 does not allow use two functions. Is there, a w...
|
-
Rodolfo Lassalle Question Asked 1 Years ago through ASK
Hi Sebastian,
I need to add the values in the field Duration and I used Sum(Duration) which work well but if need to get the average. I tried AVG(Sum(Duration)), but I got an error, look like that SQL 2005 does not allow use two functions. Is there, a ...
|
-
Rodolfo Lassalle Posted 1 Years ago through Ask
I wrote a query to get info from diff field call state I have to use aggregate function, the query is like this;Select originatorID,
i.prenom + ', ' + i.nom as "Full Name",
(Select (Sum(Duration)/100)
From [V4Archive].dbo.odAction...
|
-
Rodolfo Lassalle Question Asked 1 Years ago through ASK
I wrote a query to get info from diff field call state I have to use aggregate function, the query is like this;
**Select originatorID**, i.prenom + ', ' + i.nom as "Full Name" ,
**(Select (Sum(Duration)/100) From [V4_Archive].dbo.odActions_2012...
|