select vw_Calendar.holiday,vw_Calendar.StringDate,vw_Calendar.DayofWeek,WeekHours.UserID,WeekHours.FromHour,WeekHours.ToHour,WeekHours.Fluid,
InAndOut.EnterHour,substring( dbo.SmallDateTimeToString(InAndOut.EnterHour),0,11) as Date, substring( dbo.SmallDateTimeToString(InAndOut.EnterHour),11,6) as StartTime
,InAndOut.ExitHour,InAndOut.Status,
VW_InAndOut.presence,VW_InAndOut.activity
from vw_Calendar
inner join WeekHours on vw_Calendar.DayofWeek=WeekHours.DayofWeek
LEFT join InAndOut on vw_Calendar.StringDate=substring( dbo.SmallDateTimeToString(InAndOut.EnterHour),0,11)and InAndOut.UserID='4'
and substring( dbo.SmallDateTimeToString(InAndOut.EnterHour),0,11) >= '1397/03/01' and substring( dbo.SmallDateTimeToString(InAndOut.EnterHour),0,11) <='1397/03/21'
LEFT  join VW_InAndOut on vw_Calendar.StringDate=VW_InAndOut.date and VW_InAndOut.UserID='4' and VW_InAndOut.date >= '1397/03/01' and  VW_InAndOut.date<='1397/03/21'
where vw_Calendar.StringDate >= '1397/03/01' and vw_Calendar.StringDate<='1397/03/21' and WeekHours.UserID='4'
order by vw_Calendar.StringDate desc