http://www.kodyaz.com/t-sql/nested-cursor-in-sql-server-2008.aspx

Nested loop in sql server called as recursive CURSOR

Recursive cursor is a defining a loop in another loop in SQL Server.

Port No. 1433

@Dipak Varma Cursor is local declare then how to call another cursor.

http://sqlusa.com/bestpractices2005/doublecursor/

Whenever Insert, Update or Delete in Cursor then it can call another cursor. This can happen many times. that is call Recursive Cursor.