I bet the problem is that your view name has a space in it. I'm sure there must be a way to SELECT from that, but I don't know the syntax. Can you change the view to have the name ProjectStatus, or Project_Status, instead? Then, it should simply be a SELECT FROM ProjectStatus, or something along those lines.

~~Bonnie


>All,
>
> I am trying to create a create a stored procedure that selects data from a view. The name of my view is "project status". I have tables in the database named project and status which is what the stored procedure is returning. How do I get the stored procedure to pull data from the view("project Status")?