SQL Server 2005: How do you combine stored procedure results without using temp tables?

SELECT e.enc_nbr, pt.med_rec_nbr, p.first_name, p.middle_name, p.last_name, l.ufo_num, l.order_num, l.create_timestamp AS l_create_timestamp, l.modify_timestamp AS l_modify_timestamp, r.create_timestamp AS r_create_timestamp, r.modify_timestamp AS r_modify_timestamp, l.enc_id,  
r.req_accession, r.prod_accession, r.obs_batt_id, r.test_desc, r.coll_date_time, r.unique_obr_num
         INTO #lab_tests_tmp  
                  FROM lab_nor l WITH(NOLOCK), lab_results_obr_p r WITH(NOLOCK) ,patient_encounter e WITH(NOLOCK),
patient pt WITH(NOLOCK),person p WITH(NOLOCK)
  WHERE l.order_num = r.ngn_order_num  
AND l.enc_id = e.enc_id
AND r.person_id = p.person_id
AND p.person_id = pt.person_id
  AND (l.delete_ind <> 'Y' OR l.delete_ind IS NULL)  
  AND (r.delete_ind <> 'Y' OR r.delete_ind IS NULL)
AND ((l.create_timestamp > @pi_date) OR 
(r.create_timestamp > @pi_date))  
        
 CREATE CLUSTERED INDEX p_l_r_obr_tmp ON #lab_tests_tmp ( unique_obr_num )  
       
 SELECT distinct unique_obr_num  
         INTO #xlab  
         FROM #lab_tests_tmp r WITH(NOLOCK)  
  
 SELECT x.unique_obr_num,  
             x.obs_id, x.obs_sub_id, x.result_desc, x.observ_value, x.abnorm_flags, x.units, x.ref_range, x.obx_seq_num,   
             x.signed_off_ind, x.obs_date_time, x.create_timestamp, x.modify_timestamp, x.delete_ind, x.result_seq_num, x.comment_ind   
         INTO #lab_results_tmp  
         FROM #xlab r, lab_results_obx x WITH(NOLOCK)  
         WHERE r.unique_obr_num = x.unique_obr_num 
  AND (x.delete_ind <> 'Y' OR x.delete_ind IS NULL)  
  
  DROP TABLE #xlab  
       
  SELECT  r.enc_nbr, r.med_rec_nbr, r.first_name, r.middle_name, r.last_name,  r.ufo_num, r.req_accession, r.prod_accession, r.order_num, r.obs_batt_id, r.test_desc, x.obs_id, x.obs_sub_id, x.result_desc, x.observ_value, x.abnorm_flags,   
        r.coll_date_time, r.l_create_timestamp, r.l_modify_timestamp, r.r_create_timestamp, r.r_modify_timestamp,  x.create_timestamp AS x_create_timestamp, x.modify_timestamp AS x_modify_timestamp, x.units, x.ref_range, x.obx_seq_num, r.unique_obr_num,   
        x.signed_off_ind, x.obs_date_time, r.enc_id, x.result_seq_num, x.comment_ind   
         FROM #lab_results_tmp x, #lab_tests_tmp r  
         WHERE r.unique_obr_num = x.unique_obr_num  
			ORDER BY r.req_accession, r.unique_obr_num, x.obx_seq_num
        
 DROP TABLE #lab_tests_tmp  
 DROP TABLE  #lab_results_tmp