Need Some Direction Designing My Stored Procedure

Hi.

I am wondering if somebody out there wouldnt mind
looking over my stored procedure?

The idea behind this procedure is (was) that,

(they are numbered...)

1) the procedure checks for the existence of data in the database and

2) if no data exists (if the previous statement throws an error), then execute the insert statement

3) otherwise (data exists), execute the update


I also have "sub" error handling for each statement so, if it is executing the insert, return 99 for fail, 0 for success. the same for update.

problem is that its returning the values for the first select statement and i have no idea what is going on fir the Insert or Update statements as i cant set break points in a stored procedure.

thanks for any feedback.


Code:


ALTER PROCEDURE dbo.sp_UpdateEditProfile

(
@headline VARCHAR(50) = NULL,
@about_me TEXT = NULL,
@email_address VARCHAR(50) = NULL,
@edit_date VARCHAR(50) = NULL
)

AS

BEGIN
SELECT @edit_date = CONVERT(DATETIME,convert(char(26), getdate(), 109))
END

BEGIN

--check to see if user has data there already
1)SELECT headline, about_me FROM EditProfile WHERE email_address=@email_address

--if he doesn't,
IF @@ERROR <> 0

--this is an insert statement
BEGIN

SET ANSI_WARNINGS OFF --ansi errors on text insert

2)INSERT INTO EditProfile
(headline, about_me, email_address, edit_date)

VALUES (@headline, @about_me, @email_address, @edit_date)

SET ANSI_WARNINGS ON

IF @@ERROR <> 0

BEGIN

RETURN(99)
END

ELSE

BEGIN

RETURN(0)
END

END

--if he does
ELSE

--update the data
BEGIN

SET ANSI_WARNINGS OFF --ansi errors

3) UPDATE EditProfile
SET headline=@headline, about_me=@about_me, edit_date=@edit_date WHERE email_address=@email_address
SET ANSI_WARNINGS ON

IF @@ERROR <> 0

BEGIN

RETURN(99)
END

ELSE

BEGIN

RETURN(0)
END

END

END