DECLARE @ListStr VARCHAR(1000)
DECLARE @TB_Fee TABLE (FeeCode VARCHAR(10), Fee NUMERIC(18,2))
INSERT INTO @TB_Fee(FeeCode, Fee)
SELECT '10', 10
UNION
SELECT '11', 11
UNION
SELECT '12', 12
SELECT '10', 10
UNION
SELECT '11', 11
UNION
SELECT '12', 12
SET @ListStr = ''
SELECT @ListStr = @ListStr + '{"FeeCode":"' + FeeCode
+'","Fee":"' + CONVERT(VARCHAR(20), Fee) + '"},'
FROM @TB_Fee
+'","Fee":"' + CONVERT(VARCHAR(20), Fee) + '"},'
FROM @TB_Fee
SET @ListStr = SUBSTRING(@ListStr, 1, LEN(@ListStr) - 1)
SET @ListStr = '{[' + @ListStr + ']}'
SET @ListStr = '{[' + @ListStr + ']}'
SELECT @ListStr