Friday, 15 July 2011

Case Statement

 /*
CASE
  WHEN BooleanCondition THEN Expression
  WHEN BooleanCondition THEN Expression
    ...
  ELSE Expression
END AS Alias
 */

SELECT CustomerTypeName, [Default],
    CASE [Default]
      WHEN 1 THEN 'default type'
      WHEN 0 THEN 'alternate'
      ELSE '-'
    End as AssignStatus
  From dbo.CustomerType