>>I am try to use a bulk insert instead of looping through a result set.
Like Jim mentioned, Bulk Insert takes data from a file. What you're trying to do is supported by MySQL, where you can do this: INSERT INTO tableName (id, stringfield) VALUES (1,'foo'),(2,'bar'),(3,'zesty'),(4,'80081355') Or something to that affect. However, I'm not sure if SQL Server supports that syntax for the INSERT statement.. lemme try. And it apparently does not. rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234674 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54