I have a stored procedure that accepts no parameters, I would like to create
a view that displays the execution results of that stored procedure.
I tried avoiding writing a stored procedure at all, and simply putting all
the SQL in the view. However, the stored procedure uses temporary tables.
I also tried doing something like this :
create view ViewName
as Exec SPName
but that didn't work either (I was just coming up with ideas - don't know if
that's even possible)
The reason this has to be a view is that my client is gonna use Excel (dunno
how) to open the view, and whatever they're using to do that won't work on