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