How Do I Insert Into Multiple Tables Bases On Conditions?

I have a record that I want to insert into (2) tables. The first thing I want to do is see if a record already exists in the table for the user, if it does - I just want to skip over the insert.





next I want to do the same thing in the SW_REQUEST table. If there is a record in there for the member, I want to just skip the insert.





My code works as long as there isn't an existing record in the tables. Can someone give me a hand?








Here's what I have (and it doesn't work)








CREATE PROCEDURE b4b_sw_request





@FName as varchar(50)= NULL,


@LName as varchar(50)=NULL,


@Address1 as varchar(100) = NULL,


@Address2 as varchar(100) = NULL,


@City as varchar(50) = NULL,


@State as char(2) = NULL,


@Zip as char(5) = NULL,


@Email as varchar(100) = NULL,


@Send_Updates as smallint = '0'





AS





IF EXISTS


(SELECT FName, LName, Address1, Zip from MEMBERS WHERE FName = @FName AND LName = @LName AND Zip = @Zip)


BEGIN


RETURN


END





ELSE


BEGIN


INSERT INTO MEMBERS


(FName, LName, Address1, Address2, City, State, Zip, Email)


Values


(@FName, @LName, @Address1, @Address2, @City, @State, @Zip, @Email)


END





IF EXISTS


(SELECT MEMBER_ID FROM SW_REQUESTS WHERE MEMBER_ID = @@Identity)


BEGIN


RETURN


END





ELSE


BEGIN


INSERT INTO SW_REQUESTS


(MEMBER_ID, Send_Updates)


Values


(@@Identity, @Send_Updates)


END


GO