returning three select statements from a function

From: SP <spant1_at_aol.com>
Date: 2000/06/13
Message-ID: <uYA15.1321$Qf6.51350_at_nuq-read.news.verio.net>#1/1


[Quoted] I want to return the output from three diiferent select statements (by a [Quoted] function) like this:

name   date       issueNumber
      ----- ---------- ----------- -------

(0 row(s) affected)
r_date     prodID
           ---------- ----------- -------

(0 row(s) affected)

date issueNumber
---------- -----------
(0 row(s) affected)

I was using ref cursor to return a single select statement. Is it possible [Quoted] [Quoted] to return all three from a single function. I would appreciate your input.

SP Received on Tue Jun 13 2000 - 00:00:00 CEST

Original text of this message