fnGetRecordIDFromLinkedUserID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@UserID	int	IN
@BackOfficeSystem	int	IN

Definition

Copy



    Create FUNCTION dbo.fnGetRecordIDFromLinkedUserID(@UserID int, @BackOfficeSystem int)
        RETURNS int AS 
        BEGIN
            DECLARE @RecordID  int
            SELECT top 1 @RecordID = BackOfficeRecordID
            FROM dbo.vwBackOfficeLinkedUsers
            WHERE 
                [UserID] = @UserID and
                [BackofficeSystemID] = @BackOfficeSystem 
            order by BackOfficePeopleID desc
            return @RecordID
        END