ALTER PROCEDURE [dbo].[usp_UpdateEmployee]
/* Public */
@EmployeeID		int,
@FirstName		nvarchar(20),
@MI			nvarchar(1) = NULL,
@LastName		nvarchar(25),
@NickName		nvarchar(25) = NULL,
@EmployeeTitle		nvarchar(100),
@EWorkPh			nvarchar(25) = NULL,
@EmailAddress		nvarchar(30) = NULL,
@DeptID			nvarchar(7),
@InstructorID		bit = 0,
@LLInstructorID		bit = 0,
@MInstructorID		bit = 0,
@AmbassadorID		bit = 0,
@EagleSquadID		bit = 0,

/* Private */
@LoginName		nvarchar(50),
@EmployeeTypeID		tinyint,
@ActiveID		bit = 0,
@HourlyID		bit = 0,
@IsSD			bit = 0,
@SDID			int,
@DateOfBirth		smalldatetime,
@GenderID		bit = 0,
@Address1		nvarchar(40),
@Address2		nvarchar(40) = NULL,
@City			nvarchar(35),
@State			nvarchar(2),
@Province		nvarchar(40) = NULL,
@Zip			nvarchar(14),
@Country		nvarchar(50),
@EHomePh		nvarchar(25) = NULL,
@EPagerPh		nvarchar(25) = NULL,
@PagerPin		nvarchar(14) = NULL,
@ECellPh		nvarchar(25) = NULL,
@DateOfHire		smalldatetime

AS
BEGIN
UPDATE dbEmployeePublic.dbo.tblEmployeesPublic
SET 
nvcEmpFirstName = @FirstName,
nvcEmpMI = @MI,
nvcEmpLastName = @LastName,
nvcEmpNickName = @NickName,
nvcEmpTitle = @EmployeeTitle,
nvcEmpWorkPhone = @EWorkPh,
nvcEmpEmailAddress = @EmailAddress,
nvcEmpDepartmentID = @DeptID,
bitEmpIsInstructor = @InstructorID,
bitEmpLLInstructor = @LLInstructorID,
bitEmpMUInstructor = @MInstructorID,
bitEmpIsAmbassador = @AmbassadorID,
bitIsEagleSquadron = @EagleSquadID

WHERE
intEmployeeID = @EmployeeID

UPDATE dbEmployeePrivate.dbo.tblEmployeesPrivate
SET 
nvcEmpLoginID = @LoginName,
intEmployeeType = @EmployeeTypeID,
bitEmpIsActive = @ActiveID,
bitEmpIsHourly = @HourlyID,
bitEmpIsSeniorDirector = @IsSD,
intEmpSeniorDirectorID = @SDID,
sdtEmpDOB = @DateOfBirth,
bitEmpGender = @GenderID,
nvcEmpAddress1 = @Address1,
nvcEmpAddress2 = @Address2,
nvcEmpCity = @City,
nvcEmpState = @State,
nvcEmpProvince = @Province,
nvcEmpZip = @Zip,
nvcEmpCountry = @Country,
nvcEmpHomePhone = @EHomePh,
nvcEmpPager = @EPagerPh,
nvcEmpPagerPin = @PagerPin,
nvcEmpCellular = @ECellPh,
sdtEmpDOH = @DateOfHire

WHERE
intEmployeeID = @EmployeeID

END