Sounds simple. I have an SQL joining 6 tables, 1 Ntext cast as XML. I need to insert the result of the above in a table. say a max of 5000 records will be fetched. What is the optimum way: loop thru every record and write an insert statement OR something better!
...
Go to the complete details ...