CLIENT SUPPORT » ROHTO BUGS

dear masbin , udah bisa di test ya di client udah di deploy ke sana

package :
update function GetPositionHead

berikut updatenya :

ALTER FUNCTION [dbo].[GetPositionHead]
(
@org_unit varchar(8),
@key_date varchar(8)
)
RETURNS varchar(8)
AS

--DECLARE @org_unit varchar(8) = '00000002'
--DECLARE @key_date varchar(8) = '20170829'

BEGIN
-- Declare the return variable here
DECLARE @position_head varchar(8)

-- Add the T-SQL statements to compute the return value here
    --SELECT @position_head = dbo.[GetObjRel](@org_unit,'O','A','001','P',@key_date)
    SELECT @position_head = O2.RelationshipObject
    FROM dbo.PHROM0002 O2 INNER JOIN
    dbo.PHROM0001 O1 ON O2.RelationshipObject = O1.ObjectID     
        AND O1.StartDate <= @key_date 
        AND O1.EndDate >= @key_date    
        AND O1.ObjectClass = 'P'
        AND O1.PositionHead = '1'
    WHERE O2.ObjectID = @org_unit
        AND O2.ObjectClass = 'O'
        AND O2.RelationshipDirectory = 'A'
        AND    O2.RelationshipType = '001'
        AND O2.RelationshipClass = 'P'
        AND O2.StartDate <= @key_date
        AND O2.EndDate >= @key_date
    SET @position_head = ISNULL(@position_head,'')
    -- Return the result of the function
    RETURN @position_head

END

makasih