spUpdateResolvedBORecordIDs

Parameters

Parameter	Parameter Type	Mode
@NewBORecID	int	IN
@OldBORecID	int	IN
@BOPeopleID	int	IN
@SystemID	int	IN
Definition

Copy

            CREATE     PROCEDURE [dbo].[spUpdateResolvedBORecordIDs]
            (
                @NewBORecID        int,
                @OldBORecID        int,
                @BOPeopleID        int,
                @SystemID        int
            )
            AS
            BEGIN
                set nocount on;
                IF NOT EXISTS (
                    SELECT ID FROM dbo.BackOfficeSystemPeople WHERE BackofficeRecordID = @NewBORecID AND BackOfficeSystemID = @SystemID
                )
                BEGIN
                    UPDATE        dbo.BackOfficeSystemPeople 
                    SET BackOfficeRecordID = @NewBORecID
                    WHERE ID = @BOPeopleID 
                END

                UPDATE        dbo.ATHLETICS_EECOACHES
                SET CoachEEID = @NewBORecID
                WHERE CoachEEID = @OldBORecID

                UPDATE        dbo.ATHLETICS_ROSTERS
                SET PlayerEEID = @NewBORecID
                WHERE PlayerEEID = @OldBORecID
            END