with a (LastName, FirstName, Hobby) as 
(
values
('Иванов'    , 'Иван'      , 'Спорт'    ),
('Иванов'    , 'Иван'      , 'Машины'   ),
('Петров'    , 'Петр'      , 'Животные' ),
('Петров'    , 'Петр'      , 'Деньги'   ),
('Рожков'    , 'Андрей'    , 'Девушки'  )
),
t (level, lastName, FirstName, hobby, Hobbys) as
(
select  1 , lastName, firstName, min(hobby), cast(min(hobby) as varchar( 100 ))
from a
group by lastName, firstName
  union all
select t.level+ 1 , t.lastName, t.firstName, a.hobby, t.hobbys||' '||a.hobby
from t, a
where t.lastName=a.lastName and t.firstName=a.firstName
and a.hobby=
(
select min(hobby) 
from a a2
where a2.lastName=t.lastName and a2.firstName=t.firstName
and a2.hobby>t.hobby
)
)
select g.lastName, g.FirstName, t.Hobbys
from t
join 
(
select lastName, FirstName, max(level) as level
from t 
group by lastName, FirstName
) g on t.lastName=g.lastName and t.firstName=g.firstName and t.level=g.level;

Select hobby from table 

Hobby
__________
Спорт
Машины
Животные

Update table2 Set Hobby=?????