fnUserIDByBackOfficeID

Return

Return Type
int

Parameters

Parameter Parameter Type Mode Description
@backOfficeID int IN

Definition

Copy


        CREATE   function dbo.fnUserIDByBackOfficeID(@backOfficeID int) returns int as
        begin
            return (select top 1 [Userid]
            from vwBackOfficeLinkedUsers
            where backofficeRecordid=@backOfficeID)
        end