[GENERAL] Stored procedures from MS Query

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

Re: [GENERAL] Stored procedures from MS Query

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

Re: [GENERAL] Stored procedures from MS Query

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