DECLARE
@StartDt DATETIME = '2013-03-11 11:22:52.053'
,@Period INT = 1
,@due_date DATETIME = '2013-03-18 11:22:52.053'
UPDATE CROS_L SET DUE5 = bal_amt WHERE DATEDIFF(D,@StartDt,@due_date) >= @Period AND @due_date IS NOT NULL;
SET @Period = 10
UPDATE CROS_L SET DUE5 = bal_amt WHERE DATEDIFF(D,@StartDt,@due_date) >= @Period AND @due_date IS NOT NULL;