>CREATE PROC spUpdateValidObr > >@ObrType varchar(8) = '', >@ObrDate datetime = '', >@SuperIbm char(10) = '', >@OfficerIbm char(10) = '', >@Appearance bit = '', >@Attitude bit = '', >@Communication bit = '', >@Compatibility bit = '', >@JobKnowledge bit = '', -- these are missing: >@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 >