CLIENT SUPPORT » BANK MEGA SYARIAH ES Bugs

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
AND EndDate >= @now
group by RelationshipObject

select * from @cekdoubleOkO where countOBJ > 1
--select * from PHROM0002 where objectClass = 'O' and RelationshipDirectory = 'A' and RelationshipClass = 'O' AND StartDate <= @now
-- AND EndDate >= @now and RelationshipObject = '00000601'