The vertical and horizontal tables of SQL Server are transferred to each other

1, longitudinal table turn horizontal table

TABLE_A structure of the longitudinal table:

Post-conversion structure:

SQL example of a vertical table to a table:

SELECT Name,
SUM (case when Course = N ' language ' then Grade
ELSE 0
END) as Chinese,
SUM (case when Course = N ' math ' then Grade
ELSE 0
END) as Mathematics,
SUM (case when Course = N ' English ' then Grade
ELSE 0
END) as 中文版
FROM dbo. Table_a
GROUP by Name

2, horizontal table to the longitudinal table

Horizontal table Structure Table_b:

The converted table structure:

SQL example of a horizontal table to a vertical table:

SELECT Name,
' Chinese ' as Course,
Chinese as Score
FROM dbo. Table_b
UNION All
SELECT Name,
' Mathematics ' as Course,
Mathematics as Score
FROM dbo. Table_b
UNION All
SELECT Name,
' 中文版 ' as Course,
中文版 as Score
FROM dbo. Table_b
ORDER by Name,
Course DESC

The vertical and horizontal tables of SQL Server are transferred to each other