Subject Re: stored procedure in view supported?
Author valenciaraul2004
Hi, Robert.

look at the page 88 of the Language reference:

"NOTE. You cannot select from a view that is based on the result set
of a stored procedure."

But this is really not a problem, man. just edit your procedure (or
create another) to return the data just like the view is suppossed to
do it.



> When I use this within a view definition like this (simplified):
> CREATE VIEW MyView (ProjectId, List)
> AS
> SELECT ProjectId, List
> FROM MyStoredProc
> I get this error:
> Dynamic SQL Error
> SQL error code = -204
> Table unknown