DECLARE @AddedValuesSlices TABLE
(
   end_value INT NOT NULL PRIMARY KEY,
   slice_name VARCHAR(100) NOT NULL
);

INSERT INTO @AddedValuesSlices(end_value, slice_name)
   SELECT 0, 'No Balance' UNION ALL
   SELECT 20, '$0 - $20' UNION ALL
   SELECT 40, '$20 - $40' UNION ALL
   SELECT 60, '$40 - $60' UNION ALL
   SELECT 80, '$60 - $80' UNION ALL
   SELECT 2147483647, 'Higher Than $80';

SELECT S.[SPEND], T.[CUSTOMER COUNT]
  FROM (SELECT ISNULL(SUM(added_value), 0) AS [SPEND], COUNT(DISTINCT customer_code) AS [CUSTOMER COUNT]
          FROM dbo.CLUB_SALES) AS T
       CROSS APPLY
       (SELECT TOP(1) S.slice_name AS [SPEND]
          FROM @AddedValuesSlices AS S
         WHERE S.end_value >= T.SPEND
         ORDER BY S.end_value ASC) AS S

select 
  number, 
  convert(varchar,20*(number/20)) + ' to ' + convert(varchar,(20*(number/20)+19)) 
from master.dbo.spt_values s where s.type='P'