>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

INSERT INTO MyTable (field list here)
SELECT (field list that match field list above)
FROM MyOtherTable 

All valid selects can be used in that statement. You can use derived tables, joins WHEREs etc.
If you can get desired rowset with one select you can use that select to isert that Rowset into other table.