这应该是这个问题的答案：

IF EXISTS(select * FROM sys.views where name = 'monthnotexict')
drop view monthnotexict
go
    create view monthnotexict as
        select 1 as month_table,0 as cstart ,0 as cend  from newdata union 
        select 2 as month_table,0 as cstart ,0 as cend from newdata union 
        select 3 as month_table,0 as cstart,0 as cend from newdata union 
        select  4 as month_table,0 as cstart,0 as cend from newdata union 
        select  5 as month_table,0 as cstart,0 as cend from newdata union 
        select  6 as month_table,0 as cstart,0 as cend from newdata union 
        select  7 as month_table,0 as cstart,0 as cend from newdata union 
        select  8 as month_table,0 as cstart,0 as cend  from newdata union 
        select  9 as month_table,0 as cstart,0 as cend from newdata union 
        select  10 as month_table,0 as cstart,0 as cend from newdata union 
        select  11 as month_table,0 as cstart,0 as cend from newdata union 
        select  12 as month_table,0 as cstart,0 as cend from newdata

    go
     SELECT DATENAME(month, DATEADD(month,M.month_table-1, CAST('2008-01-01' AS datetime)))as month_table
             , sum(cstart) as cstart 
             , sum(cend) as cend 
          from monthnotexict left join
             (
              (select 
                    , 1 as cstart
                    , 0 as cend 
                 from newdata

              ) 
      union all 
              ( 
                     , 0
                     , 1 
                  from newdata 

               ) 
    union all
    (
    select
    month_table
                 , sum(cstart) as cstart 
                 , sum(cend) as cend  
        from monthnotexict
group by month_table

    )

              ) dd on dd.cend=M.cend or dd.cstart=M.cstart

  group by M.month_table

根据您在评论中的请求，我更改了代码（现在代码没有错误，月份号更改为月份名称）
我希望它完成！

你需要一张满月的table。您可以使用 UNION ALL . 然后左键将count子查询联接到该表。

SELECT m.month month_table,
       coalesce(s.count, 0) cstart,
       coalesce(e.count, 0) cend
       FROM (SELECT 1 month
             UNION ALL
             SELECT 2 month
             UNION ALL
             SELECT 3 month
             UNION ALL
             SELECT 4 month
             UNION ALL
             SELECT 5 month
             UNION ALL
             SELECT 6 month
             UNION ALL
             SELECT 7 month
             UNION ALL
             SELECT 8 month
             UNION ALL
             SELECT 9 month
             UNION ALL
             SELECT 10 month
             UNION ALL
             SELECT 11 month
             UNION ALL
             SELECT 12 month) m
            LEFT JOIN (SELECT month(n.start_date) month,
                              count(*) count
                              FROM newdata n
                              GROUP BY month(n.start_date)) s
                      ON s.month = m.month
            LEFT JOIN (SELECT month(n.end_date) month,
                              count(*) count
                              FROM newdata n
                              GROUP BY month(n.end_date)) e
                      ON e.month = m.month
       ORDER BY m.month;