SELECT * FROM [Table]

with t (Indx,Name,Summary) as
  (
    select  99,      'Овощ', 1 union all
    select 101, 'Картофель', 0 union all
    select 102,    'Огурец', 0 union all
    select 196,     'Фрукт', 1 union all
    select 201,    'Яблоко', 0 union all
    select 250,     'Ягода', 1 union all
    select 253,    'Малина', 0 union all
    select 292,  'Клубника', 0 union all
    select 303,    'Рябина', 0
  )

select name, cnt
  from (
         select v0.*, count(1) over(partition by grp_id) - 1 as cnt
           from (
                  select t.*, sum(Summary) over(order by indx) as grp_id
                    from t
                ) as v0
       ) as v1
 where Summary = 1

with x as
(
 select
  t1.Name, t1.[Index] as s, isnull(t2.[Index], 2147483647) as e
 from
  [Table] t1 outer apply
  (select top (1) [Index] from [Table] where Summary = 1 and [Index] > t1.[Index] order by [Index]) t2
 where
  t1.Summary = 1
)
select
 x.Name, count(*)
from
 x join
 [Table] t on t.Summary = 0 and t.[Index] >= x.s and t.[Index] < x.e
group by
 x.Name;

declare @t table ([index] int,name varchar(50),summ int)
insert into @t 
select 99,'Овощ',1
union all
select 101,'Картофель',0
union all
select 102,'Огурец',0
union all
select 196,'Фрукт',1
union all
select 201,'Яблоко',0
union all
select 202,'Ягода',1
union all
select 204,'Черника',0
union all
select 214,'Малина',0
union all
select 215,'Волчья',0


select Category,count(*)
from 
(
select *,((select top 1 name from @t t1 where t.[index]>=t1.[index] and t1.[summ]=1 order by [index] desc)) as Category from 
@t t ---order by [index]
) tmp
where summ=0
group by Category

select max(case when Summary = 1 then name else '' end) as name,
       count(1) - 1 as cnt
  from (
                  select t.*, sum(Summary) over(order by indx) as grp_id
                    from t
       ) as v0
 group by grp_id