Yup, it works if the number of columns should be same in all the tables. But we want the solution like getting the particular table data while executing the SP...

It is like SP 'A' is having some table and other things. Inside SP 'A' i want to call Exec SP 'B' and want to get the data which all...

I mean by retrieve. Getting the record which that SP is returning.

Thx, I got the excepted result.