Hey! Pivot Table！

	SELECT * FROM (SELECT year(invoiceDate) as [year], left(datename(month,invoicedate),3)as [month], _
	InvoiceAmount as Amount FROM Invoice) as InvoiceResult 

	SELECT *
	FROM (
	    SELECT 
	        year(invoiceDate) as [year],left(datename(month,invoicedate),3)as [month], 
	        InvoiceAmount as Amount 
	    FROM Invoice
	) as s
	PIVOT
	(
	    SUM(Amount) --可能对于原来的每个月会有多个数据，因此可以使用聚合函数
	    FOR [month] IN (jan, feb, mar, apr, 
	    may, jun, jul, aug, sep, oct, nov, dec)--只需要写字段的名称即可，不需要加单引号
	)AS pvt

    --pivot table
    SELECT top(20) *
    FROM (
        SELECT datagroupid, itemcode, textanswer
        FROM profile_data
    ) as s
    PIVOT
    (
        max(textanswer)
        FOR itemcode IN (Incident_DateReported,Incident_AssignedTo,Incident_DueDate,Incident_CloseDate,Incident_Status)
    )AS pvt