I have a Stored procedure, it have 3 different inter linked select Query, all are returns 1-5 Lakhs of records (ie Min 5 Lakhs record in 3 different Tables). The page takes lot of time to render the out put. if i run the SP in SQL server it gives result in 3 slot in 3 table.
can any body help me, how i can use the SQL server rendered different slots in my aspx page.
View Complete Post