Category Archives: Development

Coalesce Inside a Case

Got in to an instance at work where i had to modify a SP to get non-null values out of a case statement code block CASE WHEN condition_expression THEN  COALESCE(Column1, Column2) ELSE Column2 END AS New_Column Advertisements

Posted in Development | Leave a comment