CategoryUser documentation Technical documentation
Title *
Description DECLARE @now VARCHAR(10) SET @now = dbo.fn_formatdatetime(GETDATE(), 'yyyymmdd') DECLARE @cekdoubleOkP TABLE ( ObjectIDP VARCHAR(20), countOBJ VARCHAR(10) ); INSERT INTO @cekdoubleOkP select distinct RelationshipObject,COUNT(RelationshipObject) from PHROM0002 where objectClass = 'O' and RelationshipDirectory = 'A' and RelationshipClass = 'P' AND StartDate <= @now AND EndDate >= @now group by RelationshipObject,ObjectID DECLARE @cekdoubleOkPP TABLE ( StartDate VARCHAR(20), EndDate VARCHAR(10), ObjectID VARCHAR(20), ObjectClass VARCHAR(10), RelationshipDirectory VARCHAR(20), RelationshipClass VARCHAR(10), RelationshipObject VARCHAR(10) ); INSERT INTO @cekdoubleOkPP select distinct StartDate,EndDate,ObjectID,ObjectClass,RelationshipDirectory,RelationshipClass,RelationshipObject from PHROM0002 where objectClass = 'O' and RelationshipDirectory = 'A' and RelationshipClass = 'P' AND StartDate <= @now AND EndDate >= @now and RelationshipObject in (select ObjectIDP from @cekdoubleOkP) DECLARE @cekdoubleOkPPP TABLE ( ObjectIDP VARCHAR(20), countOBJ VARCHAR(10) ); INSERT INTO @cekdoubleOkPPP select RelationshipObject, count(RelationshipObject) from @cekdoubleOkPP group by RelationshipObject select * from @cekdoubleOkPPP where countOBJ > 1 --select * from PHROM0002 where objectClass = 'O' and RelationshipDirectory = 'A' and RelationshipClass = 'P' AND StartDate <= @now -- AND EndDate >= @now and RelationshipObject = '00004028'