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?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
namburi nagendraPosted Sep 7, 2015, 8:44 AM
Pankaj Kumar ChoudharyPosted Aug 31, 2015, 10:38 AM
Manas MohapatraPosted Aug 31, 2015, 7:40 AM