fnGetRecordIDFromPeopleID

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@PeopleID int IN

Definition

Copy


    create FUNCTION dbo.fnGetRecordIDFromPeopleID(@PeopleID int)
    RETURNS int AS 
    BEGIN
        DECLARE @RecordID  int
        SELECT @RecordID = BackOfficeRecordID
        FROM dbo.BackOfficeSystemPeople
        WHERE 
            [ID] = @PeopleID 
        return @RecordID 
    END