Process sp Result Set within another sp?

Forwarding
"Richard K" <rkokoski@.air-cargo-inc.com> wrote in message
news:280101c3e0f6$67f19c90$a601280a@.phx.gbl...

quote:

---

> I have a need to create an sp where inside that sp I make
> a call to another sp passing in the appropriate
> parameters then have that result set be used in a cursor
> set that I can then walk in the calling sp.
> Does anyone have any sample code I can see?
> Thanks!!
> -Richard K
>

---

One of the options is by using a Temp Table either #Table or @.Table
dependin upon your requirement.
Else evalute, if you could use a User-Defined Functions That Return a table
Data Type
HTH
Satish Balusa
Corillian Corp.
"Jamie MacLennan (MS)" <jamiemac@.online.microsoft.com> wrote in message
news:40101744$1@.news.microsoft.com...

quote:

---

> Forwarding
> "Richard K" <rkokoski@.air-cargo-inc.com> wrote in message
> news:280101c3e0f6$67f19c90$a601280a@.phx.gbl...
>

---