Table - dbo_DimProduct

CASE ProductLine 
    WHEN 'M' THEN 'Mountain' 
    WHEN 'R' THEN 'Road' 
    WHEN 'S' THEN 'Accessory' 
    WHEN 'T' THEN 'Touring' 
    ELSE 'Components' 
END

Case
    WHEN Weight IS NULL THEN 'Unknown'
    ELSE CONVERT(CHAR (5), Weight)
END

DATENAME( mm, StartDate ) + ' ' +
DATENAME( dd, StartDate ) + ', ' +
DATENAME( yy, StartDate )

CASE
    WHEN EndDate IS NULL THEN 'Active'
    ELSE
    DATENAME(mm, EndDate) + ' ' +
    DATENAME(dd, EndDate) + ', ' + 
    DATENAME(yy, EndDate)
END

CASE
    WHEN Status IS NULL THEN 'Historical'
    ELSE Status
END

CASE
    WHEN Style IS NULL THEN 'Not Applicable' 
    WHEN Style = 'U' THEN 'Unisex'
    WHEN Style = 'M' THEN 'Mens'
    WHEN Style = 'W' THEN 'Womens'   
END

CASE
    WHEN Class IS NULL THEN 'Not Applicable'
    WHEN Class = 'H' THEN  'High'
    WHEN Class = 'M' THEN 'Medium'
    WHEN Class = 'L' THEN 'Low'
END