Thread: 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 getStudents(). How do we get around this? We would be very grateful for any help! /tomas, Patrik and Siv. __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/
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 > getStudents was a table, and complains that there is > no table called getStudents(). How do we get around > this? Create a dummy table and a rule that calls this function instead of actually selecting the from the table. HTH Shridhar
Thanks Shridhar! Works like a charm! /tomas, Patrik and Siv. --- Shridhar Daithankar <shridhar_daithankar@myrealbox.com> 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 and a rule that calls this > function instead of actually > selecting the from the table. > > HTH > > Shridhar __________________________________ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/