Hello I have an application that connects to sql database
my application is multithread.
When I run the application it loads top 500k data and stores it in #temp1(connection1), i can browse, search and select data, while my thread is running and storing the other 501 to 1m data in #temp2(connection2).
My problem is temporary table can be seen in there own session. what is the other way to this? so that i can get the 501k to 1m data.
All 2 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.