possible to call multiple select statements in stored procedure code example
Example: stored procedure sql get multiple variable selects
Declare @Phone nvarchar(30);
Declare @Fax nvarchar(30);
select @Phone = phone , @Fax = fax from customer where customerID = 1;