tag:blogger.com,1999:blog-3739073232502260520.post3397055514027044117..comments2024-03-19T05:33:41.848-07:00Comments on Dinesh's Blog :::: Being Compiled ::::: Types of SQL Server Sub Queries: Self-Contained, Correlated, Scalar, Multi-Valued, Table-ValuedDinesh Priyankarahttp://www.blogger.com/profile/03528311189201964690noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3739073232502260520.post-88002159415363541392016-12-08T16:23:58.527-08:002016-12-08T16:23:58.527-08:00Thanks Wille, thanks for the comment.Thanks Wille, thanks for the comment.Dinesh Priyankarahttps://www.blogger.com/profile/03528311189201964690noreply@blogger.comtag:blogger.com,1999:blog-3739073232502260520.post-8706746164798076712016-12-08T11:08:01.357-08:002016-12-08T11:08:01.357-08:00Great post. One thing that is complicated for a be...Great post. One thing that is complicated for a beginner like me is to realize that correlated queries invole the subquery being processed for every line in the outer query. This also helps understand why the EXISTS function works the way it does on "false/true" values.<br /><br />Willehttps://www.blogger.com/profile/18317181964415015291noreply@blogger.com