View joining with stored Procedure results
I have a existing view in SQL server used by the application. I need to
join with table returned from the stored procedure. The stored procedure
does lot of things like inserting to multiple #temp tables before
returning the result.
I tried to convert the stored procedure to Table valued function. But
inserting to temp table inside the TVF causes compilation error.
Is there any other way I can achieve this.
Thanks
No comments:
Post a Comment