CLIENT SUPPORT » BANK MEGA SYARIAH ES Bugs

CategoryUser documentation Technical documentation

Title *

DescriptionDECLARE @now VARCHAR(10) SET @now = dbo.fn_formatdatetime(GETDATE(), 'yyyymmdd') DECLARE @cekdoubleOkO TABLE ( ObjectID VARCHAR(20), countOBJ VARCHAR(10) ); INSERT INTO @cekdoubleOkO select RelationshipObject, COUNT(RelationshipObject) 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'