Skip to Content
0
Former Member
Jun 23, 2014 at 01:19 PM

Is it possible to create view from stored procedure for ase 12.5?

29 Views

Suppose I have SP to return result set like:

create proc mysp

( @param varchar(30) )

as

begin

//many logic here....

select col1, col2, col3, ...

from #mytable

end

then I want to a view can get data from this sp. As this sp include many sql, not only on select. also this sp has input parameter.

For this case, any solution to create a view from this sp on ase 12.5?