Been bouncing around the MS SQL books online docs but haven't figured out a
way to do what I want.
What I'm after is a way to take the contents of a DB view and export those
contents into an external text file, much like you can do the opposite with
the SQL function BULK INSERT.
At the moment I'm doing it the hard way - query, loop on query, build up
long string, write string out to file with CFFILE. But it's slow and
clunky. I'm looking to offload the work onto the SQL server itself which
should be much faster.
Any prodding toward the solution would be greatly appreciated.
--Scott
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
