Know Present Absent from working date rage, 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

View schema
Execution time: 0,03 sec, rows selected: 10, rows affected: 13, absolute service time: 0,19 sec