| Subject | Re: ??? HELP -->Is There Any Way of returning the complete recordset instead of |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2006-01-18T11:52:02Z |
--- In firebird-support@yahoogroups.com, "kapilpatil84firebird" wrote:
Martijn said, if you want to use a stored procedure to return these
columns, you have to make each of them return variables. But I think
it is possible to write SQL that joins the output of a SP to a table,
so that something like
SELECT t.*
FROM stored_procedure() sp
LEFT JOIN table1 t on t.fieldname = sp.outputvariable
could return 70 columns.
Set
>Why do you want to use a stored procedure to return 70 columns? As
> Is There Any Way of returning the complete recordset instead of one or
> two columns
>
> Because Have to return the rows from the table which is having More
> than 70 Columns and it is not feasible to Returns 70 Variables from SP
>
> Thanks In Advance!!!
Martijn said, if you want to use a stored procedure to return these
columns, you have to make each of them return variables. But I think
it is possible to write SQL that joins the output of a SP to a table,
so that something like
SELECT t.*
FROM stored_procedure() sp
LEFT JOIN table1 t on t.fieldname = sp.outputvariable
could return 70 columns.
Set