ALTER PROCEDURE sp_InsUpdateUser
(
	@userEmail varchar(75),
	@userName nvarchar(50),
	@userPhone varchar(20),
	@userFax varchar(20),
	@userStreet varchar(100),
	@userCity varchar(100),
	@userState char(2),
	@userZip varchar(10),
	@companyName varchar(100),
	@companyTitle varchar(50),
	@preferPhoneContact bit
)
AS
	DECLARE @userID smallint
	SELECT @userID = (SELECT userID FROM t_Users WHERE userEmail=@userEmail)
	IF @userID IS NULL
		BEGIN
			INSERT INTO t_Users (userEmail,userName) VALUES (@userEmail,@userName)
			SELECT @userID=(SELECT @@IDENTITY)
		END
			
	IF @userPhone IS NOT NULL
		UPDATE t_Users SET userPhone=@userPhone WHERE userID=@userID
	IF @userFax IS NOT NULL
		UPDATE t_Users SET userFax=@userFax WHERE userID=@userID
	IF @userStreet IS NOT NULL
		UPDATE t_Users SET userStreet=@userStreet WHERE userID=@userID
	IF @userCity IS NOT NULL
		UPDATE t_Users SET userCity=@userCity WHERE userID=@userID
	IF @userState IS NOT NULL
		UPDATE t_Users SET userState=@userState WHERE userID=@userID
	IF @userZip IS NOT NULL
		UPDATE t_Users SET userZip=@userZip WHERE userID=@userID
	IF @companyName IS NOT NULL
		UPDATE t_Users SET companyName=@companyName WHERE userID=@userID
	IF @companyTitle IS NOT NULL
		UPDATE t_Users SET companyTitle=@companyTitle WHERE userID=@userID
	IF @preferPhoneContact IS NOT NULL
		UPDATE t_Users SET preferPhoneContact=@preferPhoneContact WHERE userID=@userID

	SELECT @userID
RETURN