Re: [GENERAL] Return cols and rows via stored procedure

2013-07-14 Thread David Johnston
Robert James wrote > I'd like a stored procedure which does something like: > > INSERT INTO... > SELECT... -- This should be returned as multicolumn, multifield - just > like a table or view > > When I run it, though, instead of getting a table, I get one field > with all the data in it as a comp

[GENERAL] Return cols and rows via stored procedure

2013-07-14 Thread Robert James
I'd like a stored procedure which does something like: INSERT INTO... SELECT... -- This should be returned as multicolumn, multifield - just like a table or view When I run it, though, instead of getting a table, I get one field with all the data in it as a compound type. I'd like to return the