Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bulk Collect equivalent in SQL Server Expand / Collapse
Author
Message
Posted Sunday, September 27, 2009 9:21 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, September 27, 2009 10:30 PM
Points: 83, Visits: 17
Hello Everyone,

I had a view which use to fetch lakhs of records to be displayed in a SSRS report, but it aborts since the amount of data is too much to be processed, hence came the question of performance in picture. The same applies to me with Oracle, though I got a solution for Oracle I am looking for something similar in SQL Server.

Oracle provides BULK COLLECT as one of the option to improve performance, i.e. In a stored procedure first of all I need to define a cursor, Open the cursor using BULK COLLECT option and fill it in a Global Temp table. From this temp table I can fetch records and display it on report.

I am looking for similar functionality in SQL Server.

Regards
Gurpreet
Post #794365
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse