Tony, Here's a quick tutorial on using BCP with SQL Server 2000 (with links to BCP resources on MSDN) to output text files:
http://www.sqlteam.com/item.asp?ItemID=4722 If you want to maintain portability between DBMS' by using Coldfusion to handle the export workload, Ben Nadel had a good article the other day on optimizing that process by using the Java string buffer : http://www.bennadel.com/blog/679-ColdFusion-Optimizing-Case-Study- Writing-Orders-To-A-CSV-File.htm HTH, Jon On May 16, 2007, at 3:36 PM, Tony wrote: > ok. > next question. > how in the heeeeeeeck do i do it in SQL? > im using sql server 2000. > i could use sql server 2005. > > any and ALL HELP is appreciated. > > thanks > tony > > On 5/16/07, Robertson-Ravo, Neil (RX) > <[EMAIL PROTECTED]> wrote: >> Best bet is don't do it in ColdFusion at all, let the SQL engine >> do the work >> and ref the resultant file. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278348 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
