InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 22:49:13 GMT20http://www.sqlservercentral.com/Forums/Topic654772-149-1.aspxAs told in other thread, you don't need doubled nested cursors.All it takes is one update statement and one insert statement.Wed, 11 Feb 2009 08:42:20 GMTSwePesohttp://www.sqlservercentral.com/Forums/Topic654772-149-1.aspxThanks peso... I am looking for different solutions...unfortunately i am not a T-SQL wiz and was hoping for something a little more straight forward; e.g., is there an obscure option on the FETCH statement that i could use?Wed, 11 Feb 2009 07:56:06 GMTbrd123http://www.sqlservercentral.com/Forums/Topic654772-149-1.aspxAnswered here in detail[url=http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119624]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119624[/url]Wed, 11 Feb 2009 07:37:35 GMTSwePesohttp://www.sqlservercentral.com/Forums/Topic654772-149-1.aspxHi all. I have the following code: DECLARE prod_cursor CURSORFORSELECT productid <--Problem childFROM @products OPEN prod_cursorDECLARE @prodid_ FETCH NEXT FROM prod_cursor INTO @prodid_WHILE (@@FETCH_STATUS <> -1)BEGINIF(@@FETCH_STATUS <> -2)BEGIN(line by line processing)END FETCH NEXT FROM prod_cursor INTO @prodid_ ENDCLOSE prod_cursorDEALLOCATE prod_cursorSELECT * from @prodid_ Problem is that I am getting the cursor select's result first then the last select's result set. I only want the last result set. Is there a way i can supress the cursor result set? many thanksbirdie3321Wed, 11 Feb 2009 07:01:25 GMTbrd123