You can use the square brackets to surround your object names that have space in it:

select * from [project status] ...


>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")?