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