A SQL plane question about pivot

Analysis: In fact, it is the time of the month row to the column

Table structure Design:

Results:

Select Name,moth,isnull ([01],0) as Value1,isnull ([02],0) as Value2,isnull ([03],0) as Value3 from (
Select A.name,convert (varchar (4), moth,120) as Moth,convert (varchar (2), moth,100) as Moth2,number from Table_type as a
Left join Table_shuju as B on a.id=b.id
As Table1 pivot (SUM (number) for moth2 in ([01],[02],[03])) as Table2

：

A SQL plane question about pivot