I need bcp out/in chunck of data within a SP. The logic is like
1. create local temp table
2. select data into the above local temp table
3. bcp out the data from the local temp table
Is it possible to accomplish within a SP. It seems when bcp, it establish a new session that can't access that local temp table.
Any input will be sppreciated.
Global temp table won't work for me in my situation. As this SP need create/run parallel in multiple databases in a huge SQL server (SAN) for various clients.