Table - dbo_DimReseller

CASE 
    WHEN OrderFrequency = 'A' THEN 
        'Annual'
    WHEN OrderFrequency = 'S' THEN 
        'Bi-Annual'
    ELSE 
        'Quarterly'
END

CASE 
    WHEN OrderMonth = '1' THEN 
        'January'
    WHEN OrderMonth = '2' THEN 
        'February'
    WHEN OrderMonth = '3' THEN 
        'March'
    WHEN OrderMonth = '4' THEN 
        'April'
    WHEN OrderMonth = '5' THEN 
        'May'
    WHEN OrderMonth = '6' THEN 
        'June'
    WHEN OrderMonth = '7' THEN 
        'July'
    WHEN OrderMonth = '8' THEN 
        'August'
    WHEN OrderMonth = '9' THEN 
        'September'
    WHEN OrderMonth = '10' THEN 
        'October'
    WHEN OrderMonth = '11' THEN 
        'November'
    WHEN OrderMonth = '12' THEN 
        'December'
ELSE 'Never Ordered'
END

CASE
    WHEN NOT FirstOrderYear IS NULL THEN
    CONVERT(varchar,FirstOrderYear)
    ELSE 'Never Ordered'
END

CASE
    WHEN NOT LastOrderYear IS NULL THEN
    CONVERT(varchar,LastOrderYear)
    ELSE 'Never Ordered'
END

CASE
    WHEN MinPaymentType = '1' THEN
    CONVERT(varchar, 'No Minimum')
    WHEN MinPaymentType = '2' THEN
    CONVERT(varchar, 'Percent')
    WHEN MinPaymentType = '3' THEN
    CONVERT(varchar, 'Amount')
    ELSE 'Unspecifed'
END

CASE
    WHEN NOT MinPaymentAmount IS NULL 
        THEN CONVERT(varchar, MinPaymentAmount)
    ELSE 'Not Applicable'
END