CREATE PROCEDURE sp_updateProfile
	@profileID numeric,
	@profileName varchar(100),
	@add1	varchar(100),
	@add2	varchar(100),
	@add3	varchar(100),
	@city	varchar(100),
	@state  varchar(100),
	@zip	varchar(100),
	@phone  varchar(100),
	@hours	varchar(100)
AS
UPDATE [Profile]
SET profileName= @profileName, contact = @contact, addressLine1 = @add1, addressLine2 = @add2, addressLine3 = @add3, city = @city, state = @state, zip = @zip, phoneNumber = @phone, hours = @hours
WHERE profileID = @profileID
GO	

CREATE PROCEDURE sp_insertActivity
 @userID numeric,
 @logdata varchar(1000)

as
INSERT INTO [ActLog](actTypeID,userID,actDate,actDetail) 
VALUES (15,@userID,GetDate(),@logdata)
go