how to combine multiple select statements in stored proc

Aug 31 2015 7:10 AM
how to combine multiple select statements in stored proc
 
like:
 
create procedure [somename] 
{
select A.id.A.number from a where A.id=102
select B.id from B where  where B.id=111
 
 
 
how do i get single result set? 

Answers (3)