StackOverflow question #45373363, Sql Server

Language: Layout:

CREATE TABLE tbl (name VARCHAR(8000), test_score_1 INT, test_score_2 INT, test_score_1000 INT);

INSERT INTO tbl (name, test_score_1, test_score_2, test_score_1000) VALUES ('smith', 2, 1, 0);
    INSERT INTO tbl (name, test_score_1, test_score_2, test_score_1000) VALUES ('jackson', 0, 3, 1);
    INSERT INTO tbl (name, test_score_1, test_score_2, test_score_1000) VALUES ('jackson', 1, 1, 2);
    INSERT INTO tbl (name, test_score_1, test_score_2, test_score_1000) VALUES ('jackson', 3, 0, 3);
    INSERT INTO tbl (name, test_score_1, test_score_2, test_score_1000) VALUES ('smith', 4, 5, 1);

DECLARE @cols varchar(max), @sql varchar(max);

SELECT @cols = 
         COALESCE(@cols + ', ', '') + 'SUM(' + COLUMN_NAME + ') AS ' + COLUMN_NAME
         FROM INFORMATION_SCHEMA.COLUMNS
         WHERE table_name = 'tbl'
           AND COLUMN_NAME <> 'name'
           -- The AND below is optional - see "Additional Notes #1"
           AND TABLE_CATALOG = 'rextester';
    
    SET @sql = 'SELECT name, ' + @cols + ' FROM tbl GROUP BY name;';
    
    EXEC (@sql);

View schema
Execution time: 0,03 sec, rows selected: 6, rows affected: 5, absolute service time: 0,2 sec