DECLARE @t TABLE ( [holeid] VARCHAR(30), [from] INT, [to] INT, [name] VARCHAR(30), [value] VARCHAR(30) );
INSERT INTO @t VALUES 
  ( 'hr-1', 0, 8, 'Lith_LoggedBy', 'Петров' ),
  ( 'hr-1', 8, 50, 'Lith_LoggedBy', 'Сидоров' ),
  ( 'hr-1', 50, 100, 'Lith_LoggedBy', 'Сидоров' ),
  ( 'hr-1', 100, 150, 'Lith_LoggedBy', 'Петров' ),
  ( 'hr-1', 150, 200, 'Lith_LoggedBy', 'Петров' ),
  ( 'hr-1', 200, 250, 'Lith_LoggedBy', 'Сидоров' ),
  ( 'hr-1', 250, 300, 'Lith_LoggedBy', 'Сидоров' )
;
WITH
t0 AS (
  SELECT 
    [holeid],
    [from],
    [to],
    [name],
    [value],
    [gn] = ROW_NUMBER() OVER ( PARTITION BY [holeid], [name] ORDER BY [to] )
         - ROW_NUMBER() OVER ( PARTITION BY [holeid], [name], [value] ORDER BY [to] )
  FROM
    @t
)
SELECT
  [holeid],
  [name],
  [value],
  [from] = MIN( [from] ),
  [to] = MAX( [to] )
FROM
  t0
GROUP BY
  [holeid],
  [name],
  [value],
  [gn]
ORDER BY
  [holeid],
  [name],
  [from]