Home Forums SQL Server 2012 SQL Server 2012 - T-SQL will it call subquery for every row of table with distinct in subqyery. RE: will it call subquery for every row of table with distinct in subqyery.

  • this one might be taking range lock, pls see follwing.

    http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/16/1345.aspx

    ( i have tried to add reply but it site was not adding it so you may see this post more than once)

    your sincerely