Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 nested cursor

Author  Topic 

pnpsql
Posting Yak Master

246 Posts

Posted - 2011-09-21 : 14:09:29
hi all, i use two cursors in my code , one is nested in another
how can i manage it .it goes in infinite loop please help.



challenge everything

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-21 : 14:13:00
We certainly can't help you fix a code problem without seeing your code.

Why do you need a cursor in the first place? And why oh why would you need to nest them!? Performance isn't on your list of concerns here?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

pnpsql
Posting Yak Master

246 Posts

Posted - 2011-09-21 : 14:21:36
can u help me to write a simple nested loop ..


challenge everything
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-21 : 14:46:54
That would be like me running a marathon. No. Cursors are evil. While I'll possibly help you fix your code problem, I will not partake in writing bad code.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

pnpsql
Posting Yak Master

246 Posts

Posted - 2011-09-21 : 15:08:17
x
Go to Top of Page
   

- Advertisement -