Greg Buerk
if exists (select * from sysobjects where id = object_id('dbo.RU_RATC') and
sysstat & 0xf = 4)
drop procedure dbo.RU_RATC
GO
/****** Object: Stored Procedure dbo.RU_RATC Script Date: 5/20/98
4:24:58 AM ******/
CREATE PROCEDURE RU_RATC AS
SELECT sa.Login, sa.Password, sa.AccountType, MasterExpire=DateAdd(Day,
ma.Extension, maExpireDate),
SubExpire=DateAdd(Day, sa.Extension, saExpireDate)
From MasterAccounts ma, SubAccounts sa
Where ma.CustomerID = sa.CustomerID
AND DateAdd(Day, ma.Extension, maExpireDate) >= GetDate()
AND sa.Login is not null
AND ma.Active = 1 AND sa.Active = 1
AND NOT EXISTS ( Select * From RadConfigs rc where
sa.AccountID = rc.AccountID
)
AND EXISTS (
Select * From RadATConfigs at where sa.AccountType =
at.AccountType
)
GO
GRANT EXECUTE ON dbo.RU_RATC TO RadUser
GO
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart