Replacing UNION with CASE

(Craig Mullins) When a UNION is required to put together data from multiple queries, you might be able to use a CASE statement instead. This is very useful, particularly when the data for each of the queries in the UNION come from the same table. The CASE statement can potentially enhance performanc

Read More - Register for Free Membership