CLIENT SUPPORT » BANK MEGA SYARIAH ES Bugs

DECLARE @now VARCHAR
SET @now = dbo.fn_formatdatetime(GETDATE, 'yyyymmdd')

DECLARE @cekdoubleOkP TABLE (
ObjectIDP VARCHAR,
countOBJ VARCHAR

);
INSERT INTO @cekdoubleOkP
select distinct RelationshipObject,COUNT from PHROM0002 where objectClass = 'O' and RelationshipDirectory = 'A' and RelationshipClass = 'P' AND StartDate <= @now
...

DECLARE @now VARCHAR
SET @now = dbo.fn_formatdatetime(GETDATE, 'yyyymmdd')

DECLARE @cekdoubleOkO TABLE (
ObjectID VARCHAR,
countOBJ VARCHAR
);
INSERT INTO @cekdoubleOkO
select RelationshipObject, COUNT from PHROM0002 where objectClass = 'O' and RelationshipDirectory = 'A' and RelationshipClass = 'O' AND StartDate <= @now
...