Using T-SQL’s COALESCE Function

(Richard Carr) In denormalised databases, such as those used for reporting purposes or to feed data warehouses, it is common to need to query information from a group of columns where only one has a value. This can be simplified with the coalesce function.

Read More - Register for Free Membership