fnGetPeopleID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@RecordID	int	IN
@BackOfficeSystemID	int	IN

Definition

Copy



    Create FUNCTION dbo.fnGetPeopleID(@RecordID int, @BackOfficeSystemID int)
    RETURNS int AS 
    BEGIN
        DECLARE @PeopleID  int
        SELECT @PeopleID = ID
        FROM dbo.BackOfficeSystemPeople
        WHERE 
            [BackofficeRecordID] = @RecordID and
            [BackofficeSystemID] = @BackOfficeSystemID

        return @PeopleID
    END