> As I stated previously, if the > SELECT INTO clause returns more than one record, the database will throw an > exception. If the SELECT INTO would not work, then it would not exist in > the SQL specification. :-)
Just a minor clarification, even though it might not solve your problem. You said you can't do a select into when the select returns more than one row. However, in your original SQL statement (in your very first message) you have "insert into myTable (fields) select ...". To be clear, this is not a select into...those are two different things. You may be aware of this, but for those following along in the thread I wanted to clarify. But just in case you are actually referring to an "insert into myTable select ...", you can in fact grab more than one row in the select and SQL Server will insert them just fine. I have not closely followed all of the messages in this thread, so if you are talking about something completely different, feel free to ignore me. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:338604 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
