Hi,

Currently, lot of my Stored procedure is using lot of cursor to update/insert data. I come across some articles from www.sqlservercentral on how to replace cursor with loop and select statement. The articles is excellence on opening my mind to new way of writing SQL statement but it didn't give me any guide on how to replace my code of inserting new data without using cursor or loop. Anyone know of any good way to insert new data without using cursor or loop, please share with us. Please do not use "select (columns) into (some table)" method. Thank you