3
Answers

how to combine multiple select statements in stored proc

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)