I have an application that needs to run a query against a 2005 database and then export that data to a .csv file. I tried BCP first and it didn't do what I needed really so then I moved to sqlcmd, which had the options I needed. The problem is sometimes the queries the users build in the interface to pull the records get quite large. Some have IN clauses with several thousand items in the list. Both bcp and sqlcmd die on these because the command arguments are too long. The quires run fine in coldfusion and in the query analyzer, I just can't find a method to pull out the records. Any ideas??
Thanks Jeremy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237087 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
