DECLARE @HTML VARCHAR(MAX)
SELECT @HTML='
Fifty Shades of Gray.
You''ve read the book, now here is the colour-chart.
'
SELECT @HTML=@HTML+
REPLACE(REPLACE('
','@1@',NAME),'@2@',hue)
FROM (
SELECT 'gray7' AS Name, '#121212' as hue UNION ALL
SELECT 'gray11', '#1C1C1C' UNION ALL
SELECT 'gray15', '#262626' UNION ALL
SELECT 'gray17', '#2B2B2B' UNION ALL
SELECT 'gray19', '#303030' UNION ALL
SELECT 'gray21', '#363636' UNION ALL
SELECT 'gray23', '#3B3B3B' UNION ALL
SELECT 'gray25', '#404040' UNION ALL
SELECT 'gray27', '#454545' UNION ALL
SELECT 'gray29', '#4A4A4A' UNION ALL
SELECT 'gray31', '#4F4F4F' UNION ALL
SELECT 'gray33', '#555555' UNION ALL
SELECT 'gray35', '#595959' UNION ALL
SELECT 'gray37', '#5E5E5E' UNION ALL
SELECT 'dimgray', '#696969' UNION ALL
SELECT 'gray43', '#6E6E6E' UNION ALL
SELECT 'gray45', '#737373' UNION ALL
SELECT 'gray47', '#787878' UNION ALL
SELECT 'gray49', '#7D7D7D' UNION ALL
SELECT 'gray', '#808080' UNION ALL
SELECT 'gray51', '#828282' UNION ALL
SELECT 'gray53', '#878787' UNION ALL
SELECT 'gray55', '#8C8C8C' UNION ALL
SELECT 'gray57', '#919191' UNION ALL
SELECT 'gray59', '#969696' UNION ALL
SELECT 'gray61', '#9C9C9C' UNION ALL
SELECT 'gray63', '#A1A1A1' UNION ALL
SELECT 'gray65', '#A6A6A6' UNION ALL
SELECT 'darkgray', '#A9A9A9' UNION ALL
SELECT 'gray67', '#ABABAB' UNION ALL
SELECT 'sgilightgray', '#AAAAAA' UNION ALL
SELECT 'gray69', '#B0B0B0' UNION ALL
SELECT 'gray71', '#B5B5B5' UNION ALL
SELECT 'gray73', '#BABABA' UNION ALL
SELECT 'silver', '#C0C0C0' UNION ALL
SELECT 'gray75', '#BFBFBF' UNION ALL
SELECT 'gray77', '#C4C4C4' UNION ALL
SELECT 'gray79', '#C9C9C9' UNION ALL
SELECT 'verylightgrey', '#CDCDCD' UNION ALL
SELECT 'gray81', '#CFCFCF' UNION ALL
SELECT 'lightgray', '#D3D3D3' UNION ALL
SELECT 'gray85', '#D9D9D9' UNION ALL
SELECT 'gainsboro', '#DCDCDC' UNION ALL
SELECT 'gray87', '#DEDEDE' UNION ALL
SELECT 'gray89', '#E3E3E3' UNION ALL
SELECT 'gray91', '#E8E8E8' UNION ALL
SELECT 'gray93', '#EDEDED' UNION ALL
SELECT 'gray95', '#F2F2F2' UNION ALL
SELECT 'whitesmoke', '#F5F5F5' UNION ALL
SELECT 'Gray98', '#FAFAFA' ) hues
SELECT @HTML+'
'