How Do I Access The Results Of A Query In The Stored Procedure Itself ??

Hi
I've run into a slight problem with my stored procedure.
If I fire a query in a stored procedure, how can I access the results of that query in the stored procedure itself ?? 
ALTER PROCEDURE GetDetailsOfWebsiteUserForMail
    @request_id int
AS
    declare @k int
    select person_id from Website_user w, Request r
    where r.user_id=w.user_id and r.request_id=@request_id
   
    set @k =person_id /* What do I do here??, value returned is unique */
      
    if (@k!=0)  /* Exists */
        begin
         /*  do something */
        end
       
    else /* entry on person table does not exist */
        begin
          /*  do something */

        end