我会创建一个词典表格！



试试这个：

I'd create a "dictionary" table!

Try this:

DECLARE @tmp TABLE(OldStatus, NewStatus)
INSERT INTO @tmp(OldStatus, NewStatus)
VALUES('s_1', 'Pending'), ('s_1', 'Complete')

SELECT Date, [Pending], [Complete], [Pending] + [Complete] AS  [Total]
FROM (
    SELECT A.Date, B.NewStatus AS Status 
    FROM #Temp AS A INNER JOIN @tmp AS B ON A.Status = B.OldStatus
) AS DT
PIVOT(COUNT(Date) FOR Status IN([Pending], [Complete], [Total])) AS PV