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.

Regards.

Raul.

> 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
> MYSTOREDPROC
>