Stored Procedures Inside of Views

ea · December 8th, 2004, 01:42 PM

Is this allowed? I want to retrieve results of a Select statement that has parameters and that statement within another view.

If a stored procedure returns a result set, could it be included in a view? If so, how? If not, how do you go around it?

Thanks for any help,
ea

jemacc · December 8th, 2004, 07:07 PM

Not quite clear, can you explain it little bit more

Also think about use dynamic SQL

for example:

Code:

exec ('create view test as select * from employees where [reportsto]=2'

Jaime E. Maccou

ea · December 9th, 2004, 10:19 AM

Thanks for responding. I wanted to know if there was a way to use stored procedures inside of a view. I've got these queries that use parameters so I had to make them stored procedures. However the SP returns a result set which I would like to use inside a view. I wanted to know if that was allowed. And if not, is there a work-around for it.

ea

jemacc · December 9th, 2004, 06:11 PM

Can you post your view and or store procedure?

Jaime E. Maccou