Hi!
We're trying to call a set-returning stored procedure
from Excel (MS Query). To do this we type:
select * from getStudents()
(where getStudents() is the stored procedure).
The problem is that MS Query interprets this as if
getStudents was a table, and complains that there is
no table called
Thanks Shridhar!
Works like a charm!
/tomas, Patrik and Siv.
--- Shridhar Daithankar
<[EMAIL PROTECTED]> wrote:
> On Tuesday 28 October 2003 16:06, Tomas Larsson
> wrote:
> > Hi!
> >
> > We're trying to call a set-returning stored
> procedure
> > from Excel (MS Query).
> Create a dummy table a
On Tuesday 28 October 2003 16:06, Tomas Larsson wrote:
> Hi!
>
> We're trying to call a set-returning stored procedure
> from Excel (MS Query). To do this we type:
>
> select * from getStudents()
>
> (where getStudents() is the stored procedure).
> The problem is that MS Query interprets this as if