1)I'm trying to select USERS_ID_1, UserId_2 from one

table where email = email (this seems to work), 

if it finds record update account (seems to work) and

passback progress, USERS_ID_1

and UserId_2,(does not work) but all I get passed back

is progress?

What wrong here?

thanks



+++++++++++++++++++++++++

CREATE PROCEDURE sp_validateuser 

@user_email varchar(80) = NULL, 

AS 

DECLARE @USERS_ID_1 varchar(100)

DECLARE @UserId_2 varchar(100)

IF Exists(Select USERS_ID_1, UserId_2, Email,

FirstName,

LastName From USERS_TABLE WHERE Email = @user_email)

BEGIN 

UPDATE USERS_TABLE SET ACTIVE = 1

WHERE Email = @user_email  

Select Progress =1,USERS_ID_1 = @USERS_ID_1, UserId_2

= @UserId_2

Return

END