Last post Nov 20, 2018 03:24 AM by Fei Han - MSFT
Nov 18, 2018 10:19 PM|durgaprasad.kinthada|LINK
I have requirement that would be
stored procedure having
below queries like
select * from t1
select * from t2
select * from t3
above result sets each having almost 100,000 records.
I have to display 3 restult sets in 3 pages.
when exporting to excel sheet should be display with 3 tabs.
what is the best way to handle (without impacting performance.).
First page or table should have all 100000 records.
second page should have all 100000 records.
Third page should have all 100000 records.
Please suggest me best way to implement it.
Nov 20, 2018 03:24 AM|Fei Han - MSFT|LINK
You can try to write your stored procedure with accepting parameters that indicates which table should be queried and the index of page that should display returned records.
Besides, you can post your question in SQL Server Reporting Services support forum.