I have inherited this stored proc and was told not to modify any of them if possible. I have never seen this before.
ALTER proc [dbo].[sp_GetRequestor]
set nocount on
-- return requestor recordset
select * from
where Requestor_id = @requestor_id
-- return last 3 phone/fax numbers used
select * from tbl_requestor_phone_history
where requestor_id = @requestor_id
order by requestor_id, number_type, pid desc
This will be used in visual studio 2010 so I am not sure how to retrieve all the data from both selects.
*** Please allow me to mark threads as answered and I will, Thank you ***
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.