Hi there,

I want to use a stored procedure to creat a view.
What would be the best solution for this?

Thank you very much

why do you want to create a view inside a procedure?

Somebody else is creating a web report from a view. (an existing one)
In fact I had to modify that view but I can not use temporary tables.
So I created a SP to be used for that report.

Thank you

thats fine. but why do you need to create a view for that. you can just create a sp which gives resultset that report can make use of.

also not a good method to create a view inside procedure (you dont need to). If you need a view at all, creation has to happen before procedure.