10.09.2021
23:48
Hello.
Is there a way to use a stored procedure as datasource instead of a view or table or Select statement?
I use at the moment a query on two tables (UNION) which has an inner join on another table. The speed is not really breathtaking, thus I wanted to use a stored procedure where I can perform all the timetaking steps already on the SQL server.
Regards
Klaus
11.09.2021
00:48
Hi Klaus,
maybe you can change your procedure to a table-valued function, than you could easily use it in an select statement.
An example using one of the provided table-valued functions in the BPS content db:
select item
from dbo.SplitToTable('a,b,c,d',',')
Otherwise you could test this approach, which I didn't test myself.
http://www.techbrothersit.com/2014/08/tsql-how-to-execute-stored-procedure-in.html
Best regards,
Daniel
13.09.2021
19:45
Hi Klaus,
maybe you can change your procedure to a table-valued function, than you could easily use it in an select statement.
An example using one of the provided table-valued functions in the BPS content db:
select item
from dbo.SplitToTable('a,b,c,d',',')
Otherwise you could test this approach, which I didn't test myself.
http://www.techbrothersit.com/2014/08/tsql-how-to-execute-stored-procedure-in.html
Best regards,
Daniel
Hi Daniel,
the hint with the table-valued function was great. I have to chance the setup a bit, because the gain in speed wasn't as expected, but I have plenty of ideas to use this.
The approach shown in the link doesn't work as I can't change the database to allow "Data Access".
Kind regards
Klaus
