In Microsoft SQL Server 2000, when you use a CASE function that contains a subquery for the THEN expression, the subquery is evaluated even if the condition in the WHEN expression is false.
Read More - Register for Free Membership
In Microsoft SQL Server 2000, when you use a CASE function that contains a subquery for the THEN expression, the subquery is evaluated even if the condition in the WHEN expression is false.
Read More - Register for Free Membership