Know Present Absent from working date range, Sql Server

Language: Layout:

CREATE TABLE [tt](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [UserId] [varchar](20) NULL,
    [EmpCode] [varchar](50) NULL,
    [Name] [varchar](200) NULL,
    [WorkDate] [varchar](20) NULL,
    [InTime] [varchar](20) NULL,
    [OutTime] [varchar](20) NULL,
    [TotalTime] [varchar](50) NULL,
)
insert into [tt] values
  ('106','E2E106','Goutam Kumar','2017-02-21','12:54:54 PM','10:06:42 PM','08:55:00')
 ,('106','E2E106','Goutam Kumar','2017-02-20','12:49:21 PM','09:26:27 PM','07:53:00')
 ,('106','E2E106','Goutam Kumar','2017-02-15','12:31:51 PM','09:21:14 PM','08:30:00')
 ,('106','E2E106','Goutam Kumar','2017-02-13','05:46:06 PM','09:32:17 PM','03:46:00')
 ,('106','E2E106','Goutam Kumar','2017-02-14','01:02:28 PM','09:32:50 PM','07:39:00')
 ,('111','E2E111','Mansi Manchanda','2017-02-21','12:42:42 PM','09:09:42 PM','08:07:00')
 ,('111','E2E111','Mansi Manchanda','2017-02-17','12:09:11 PM','09:40:46 PM','06:36:00')
 ,('111','E2E111','Mansi Manchanda','2017-02-16','11:56:21 AM','09:20:08 PM','08:07:00')
 ,('111','E2E111','Mansi Manchanda','2017-02-15','01:07:19 PM','09:57:40 PM','08:30:00')

CREATE TABLE tUserInfo(
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [UserId] [nvarchar](20) NULL,
    [Name] [nvarchar](200) NULL,
    [EmpCode] [varchar](200) NULL,
 )
INSERT into tUserInfo VALUES 
('106','Goutam Kumar','E2E106')      
,('111','Mansi Manchanda','E2E111')
,('112','Arvind Kumar Prajapati','E2E112')
,('116','Rahul Garg','E2E116')

declare @fromdate date = '20170201'
declare @thrudate date = '20170214'

/* absent for entire duration */
select * 
from tUserInfo as u
where not exists (
  select 1 
  from tt
  where tt.UserId = u.UserId
    and tt.WorkDate >= @fromdate
    and tt.WorkDate <= @thrudate
    )
/* present at least once */
select * 
from tUserInfo as u
where exists (
  select 1 
  from tt
  where tt.UserId = u.UserId
    and tt.WorkDate >= @fromdate
    and tt.WorkDate <= @thrudate
    )
/* show all users, and either absent entire time or present at least once */
select u.*
  , [Status]=case when x.WorkDate is null then 'Absent' else 'Present' end
from tUserInfo as u
outer apply (
  select top 1 tt.WorkDate 
  from tt
  where tt.UserId = u.UserId
    and tt.WorkDate >= @fromdate
    and tt.WorkDate <= @thrudate
    ) as x

/* To know who was absent and who was present for each `workday` during the date range: */

select 
        u.UserId
      , u.Name
      , d.WorkDate
      , [Status] = case when x.WorkDate is null then 'Absent' else 'Present' end
    from (select distinct UserId, Name from tUserInfo) as u
      cross join (
        select distinct 
            WorkDate 
        from tt
        where tt.WorkDate >= @fromdate
          and tt.WorkDate <= @thrudate
          ) as d
    outer apply (
      select top 1 tt.WorkDate 
      from tt
      where tt.UserId   = u.UserId
        and tt.WorkDate = d.WorkDate
        ) as x

View schema
Execution time: 0,05 sec, rows selected: 18, rows affected: 13, absolute service time: 0,2 sec