Re: [Emerald] Limiting number of hours per month

Dale E. Reed Jr. ( (no email) )
Mon, 28 Jun 1999 21:26:01 -0700

david leigh wrote:
>
> I'd be interested in seeing this script - perhaps you could post it
> somewhere on the ftp site?

In order for this to work, three things need to be configured:

1) The user's initial Time left MUST NOT be NULL. You can take off the
requirement by removing the timeleft check in the proc. The

2) The servie's AccountTypes must have a rate with the Overtime checked.

3) The StandardTime/StandardInterval is used to determine what the
full time is.

-------------------------------------------------------------

Use Emerald
GO

Create Proc Update_TimeLeft AS
Update sa
Set sa.TimeLeft = (rt.StandardHours * rt.StandardInterval) / 60