Re: [Emerald] Time usage

DAN TANG ( (no email) )
Mon, 26 Jul 1999 16:28:22 +0800

CREATE PROCEDURE WebDialupUsage
@CustomerID int,
@BeginDate datetime,
@FinishDate datetime
AS
select
Convert(varchar,DateAdd (ss, -AcctSessionTime, CallDate),0),
Convert(varchar,CallDate,0),
AcctSessionTime/60,
AcctInputOctets,
AcctOutputOctets,
username
from calls inner join subaccounts on calls.username=subaccounts.login
where CustomerID=@CustomerID
and AcctStatusType=2
and calldate >= @BeginDate
and calldate <= @FinishDate
ORDER BY Login,calldate desc

Regards,

Dan Tang
Network Operation
Domain Technology
----- Original Message -----
From: talon <talon@virtualight.net>
To: <emerald@iea-software.com>
Sent: Saturday, July 24, 1999 12:49 AM
Subject: [Emerald] Time usage

> Anyone have sql script that will get the username, and # of hours
> used between a certain time frame.. like.. # of hours used
> from July 1st - August 1
>
> Tim
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart