CREATE PROC spUpdateValidObr @ObrType varchar(8) = '', @ObrDate datetime = '', @SuperIbm char(10) = '', @OfficerIbm char(10) = '', @Appearance bit = '', @Attitude bit = '', @Communication bit = '', @Compatibility bit = '', @JobKnowledge bit = '', @Judgement bit = '', @Productivity bit = '', @Receptiveness bit = '', @PublicDealing bit = '', @Reliability bit = '', @UseOfEquipment bit = '', @Narrative char(2500) = '', @OfficerLastName char(25) = '', @OfficerFirstName char(20) = '', @OfficerRank varchar(30) = '', @Precinct char(30) = '', @Shift char(1) = '', @SuperLastName char(25) = '', @SuperFirstName char(20) = '', @SuperRank varchar(30) = '', @lnID INT AS --Declare Varables DECLARE @Error INT -- Do the actual UPDATE UPDATE dbo.OBR SET ObrType = @ObrType, ObrDate = @ObrDate, SuperIbm = @SuperIbm, OfficerIbm = @OfficerIbm, Appearance = @Appearance, Attitude = @Attitude, Communication = @Communication, Compatibility = @Compatibility, JobKnowledge = @JobKnowledge, Judgement = @Judgement, Productivity = @Productivity, Receptiveness = @Receptiveness, PublicDealing = @PublicDealing, Reliability = @Reliability, UseOfEquipment = @UseOfEquipment, Narrative = @Narrative WHERE obrID = @lnID UPDATE dbo.OBRName SET OfficerLastName = @OfficerLastName, OfficerFirstName = @OfficerFirstName, OfficerRank = @OfficerRank, OfficerIbm = @OfficerIbm, Precinct = @Precinct, Shift = @Shift, SuperLastName = @SuperLastName, SuperFirstName = @SuperFirstName, SuperIbm = @SuperIbm, SuperRank = @SuperRank WHERE OBRLink = @lnID