fnGetEEIDFromLinkedUserID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@UserID	int	IN

Definition

Copy



    create FUNCTION dbo.fnGetEEIDFromLinkedUserID(@UserID int)
        RETURNS int AS 
        BEGIN
            DECLARE @EEID  int
            SELECT top 1 @EEID = BackOfficeRecordID
            FROM dbo.vwBackOfficeLinkedUsers
            WHERE 
                [UserID] = @UserID and
                [BackofficeSystemID] = 1
            order by BackofficePeopleID desc
            return @EEID
        END