select  tbl.Userid
    ,   (   select  case when dateadd(day, number, '20180101') between tbl.DateFrom and tbl.DateTo then '0' else '_' end as 'data()'
            from    master..spt_values as sv 
            where   sv.type = 'P' 
                and sv.number < 365
             for xml path (''))
from    (values(1, cast('20180101' as date), cast('20180201' as date)), (2, '20180115', '20180605'), (3, '20180606', '20181001')) as tbl(Userid, DateFrom, DateTo)

declare @tbl table (Id int identity (1, 1), UserName nvarchar(100), DateFrom date, DateTo date);
insert into @tbl
        (UserName, DateFrom, DateTo)
values('Randomuser1', cast('20180101' as date), cast('20180201' as date)), ('Randomuser2', '20180115', '20180605'), ('Randomuser1', '20180606', '20181001');

WITH XMLNAMESPACES (default 'http://www.w3.org/2000/svg')  
select  (select count(id) from @tbl as t) * 30 + 15 as [@height]
    ,   500 as [@width]
    ,   (   select  130 as [@x1]
                ,   130 as [@x2]
                ,   0 as [@y1]
                ,   (select count(id) from @tbl as t) * 30 + 15 as [@y2]
                ,   'stroke:black;stroke-width:1;' as [@style]
            for xml path('line'), type)
    ,   (   select  10 as [@x]
                ,   tbl.Id * 30 as [@y]
                ,   UserName as 'data()'
            from    @tbl as tbl
            for xml path('text'), type)
    ,   (   select  135 + datediff(day, '20180101', DateFrom) as [@x1]
                ,   135 + datediff(day, '20180101', DateTo) as [@x2]
                ,   tbl.Id * 30 - 5 as [@y1]
                ,   tbl.Id * 30 - 5 as [@y2]
                ,   'stroke:black;stroke-width:10;' as [@style]
            from    @tbl as tbl
            for xml path('line'), type)
from    (values (1)) as svg (t)
for xml path('svg'), type