求一条关于SQL 统计的语句

[曾永红_]

CREATE TABLE [dbo].[ResultInfo](
[LogId] [bigint] IDENTITY(1,1) NOT NULL,
[StartTime] [datetime] NULL,
[EndTime] [datetime] NULL,
[Result] [bit] NULL,
[RunTime] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


求一条SQL 语句，能够统计按以下的形式统计出结果(Pass和Fail的值来自于Result，true为Pass，false为Fail)，需要将行中的Result字段转为列：

StartTime Fail Pass Total
2017-01-01 10 1 11
2017-01-02 11 1 11

[二月十六]

SELECT  StartTime ,
        SUM(CASE WHEN Result = 'false' THEN 1
                 ELSE 0
            END) AS Fail ,
        SUM(CASE WHEN Result = 'true' THEN 1
                 ELSE 0
            END) AS Pass ,
        COUNT(1) AS Total
FROM    [ResultInfo]
GROUP BY StartTime