Queries and Cursors
Will queries internal having one or more subquery result in cursors at SQL Server level.
In otherwords I am not explicitly using cursors but i have query with a sub query. Now for processing this query will SQL server create cursors internally.
No sql server do not create any cursotr the subquery. go trough the below link for more details
There are two kinds of subqueries: standard and correlated. The standard subquery executes once, and its results are fed into the parent query. A correlated subquery executes once for every row retrieved by the parent query. In this tip, I shed some light on the power of nested subqueries (I'll save correlated subqueries for another day).