SQL Server Performance Forum – Threads Archive
How to do join inside a case statementHow to do join inside a case statement
CASE WHEN @mSupCoun = ” THEN 1 ELSE CASE WHEN t.ClinNo IN (SELECT ClinNo FROM tblClient WHERE SupCounNo = @mSupCoun) THEN 1 ELSE 0 END END = 1
How can I replace clinno in the above with the join on clinno instead?
I don’t understand the question… Are you able to post the complete query plus what you think the query should look like (even if the syntax is invalid…)? Twan