Subject SP not returning a table
Author Alejandro Garcia
I've finished a stored procedure and I need it to return mytable (that I modify in the stored procedure) so I just added a SELECT * from mytable as the last line of the stored procedure but I'm getting an error:

SQL error code = -104.
Token unknown - line 74, char 22.
;.

But a table can't be an output parameter of a SP, should I execute the SP and then show mytable doing the SELECT outside the SP?


---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com

[Non-text portions of this message have been removed]