spGetBackOfficeSystemPeopleID

CREATE PROCEDURE [dbo].[spGetBackOfficeSystemPeopleID](
    @BackOfficeRecordID int,
    @BackOfficeSystemID int,
    @BackOfficeSystemPeopleID int output)
as
begin
    set nocount on

    begin transaction

    set @BackOfficeSystemPeopleID = null

    if @BackOfficeRecordID > 0 
    BEGIN
        select @BackOfficeSystemPeopleID = [ID] 
        from BackOfficeSystemPeople
        where BackOfficeRecordID = @BackOfficeRecordID 
        and BackOfficeSystemID = @BackOfficeSystemID

        if @BackOfficeSystemPeopleID is null
        begin
            insert into BackOfficeSystemPeople (
                BackOfficeSystemID,
                BackOfficeRecordID)
            values (
                @BackOfficeSystemID,
                @BackOfficeRecordID
            )

            SELECT @BackOfficeSystemPeopleID = @@Identity    
        end
    END

    commit
end