The easiest way is to do this within SQL Server Management Studio. There are a few methods of exporting data built into that product, all of them easy to use.
-Mike Chabot On Wed, Feb 2, 2011 at 2:31 PM, Richard Steele <r...@photoeye.com> wrote: > > Is there an easy way to export SQL query data into a tab delimited or CSV > format? I know I can do this with a loop and variables, but it seems like > there should be an easier way. (my query has 100+ column names!). Thanks in > advance. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm