CASE WHEN M.MetricType = 'P'
THEN CASE WHEN NU.FromFrequency = 1 THEN 'One'
WHEN NU.FromFrequency = 2 THEN 'Two'
WHEN NU.FromFrequency = 3 THEN 'Three'
WHEN NU.FromFrequency = 4 THEN 'Four'
WHEN NU.FromFrequency = 5 THEN 'Five'
ELSE '' END +' '+'to'+' '+
CASE WHEN NU.ToFrequency = 6 THEN 'One'
WHEN NU.ToFrequency = 7 THEN 'Two'
WHEN NU.ToFrequency = 8 THEN 'Three'
WHEN NU.ToFrequency = 9 THEN 'Four'
WHEN NU.ToFrequency = 10 THEN 'Five' END +' '+
CASE WHEN NU.ToFrequency = 6 THEN 'time'
WHEN NU.ToFrequency = 10 THEN 'times Or greater'
else 'times' END
WHEN M.MetricType = 'o' THEN CAST(NU.FromOperator AS VARCHAR) + ' ' +CAST(NU.FromFrequency as varchar) + ' ' + CAST(NU.ToOperator as varchar) ELSE ''
END AS Frequency
--
Chandu