We use Rodopi 5.2 sp3 and I have been passed the request to NOT put
customers on hold for late payment on the weekends when our accounting staff is
not available. I believe I have found the stored procedure that puts the
accounts on hold but I wanted to check with some of you Rodopi and SQL
gurus to be sure I'm looking in the right place, as well as make sure this
should work and not cause any additional problems. Below are the first
dozen or so lines of the SP along with my simple edit. If I am correct,
this should prevent the procedure from running on Saturday and Sunday and if I
am reading the procedure correctly, any users who would have went on hold over
the weekend will be found and put on hold when the procedure runs on
Monday. Anyone see any errors in my thinking?
CREATE Procedure
Maint_OnHoldLateSuspend
@CustomerID int = NULL,
@Proc int
= 0 output
As
set nocount on
if datename(dw, getdate()) IN
('Saturday', 'Sunday')
return
0
select @Proc= 0
declare @DateLateSuspCC
smalldatetime,
@DateLateSuspCheck
smalldatetime,
@DateLateSuspACH
smalldatetime,
@DateLateSuspCorpCheck
smalldatetime,
@BillingDate
smalldatetime
