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.
| Author |
Topic |
|
sanjay_jadam
Yak Posting Veteran
53 Posts |
 Posted - 2005-10-14 : 03:22:02
|
| Hi,I would like to knowWhat is Corelated SubQueries??Thanks in Advance |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-14 : 04:09:20
|
| Do you have SQL Server installed?In Books On Line, SQL Server help file, see the topic subqueries which will tell all types of itMadhivananFailing to plan is Planning to fail |
 |
|
|
sanjay_jadam
Yak Posting Veteran
53 Posts |
Posted - 2005-10-14 : 04:55:18
|
| All the previous examples of subqueries evaluated the innermost query completely before moving to the next level of the query. Some queries, however, cannot be completely evaluated before the outer, or main, query is evaluated. Instead, the search condition of a subquery depends on a value in each row of the table named in the outer query. Therefore, the subquery is evaluated repeatedly, once for each row selected from the outer table. This type of subquery is referred to as a correlated subquery. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-14 : 05:28:38
|
Good to know your answer  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Subqueries