Title: tbs fingerprint                                 If you need copy same format use firefox or chrome or safari but iexplorer not work


Preview of Code
SELECT     TA_UserID as empid,TA_UserFirstName + ` ` +TA_UserLastName as fullname,CONVERT(nvarchar(11), TA_LocalTimestamp, 120) AS dates,FORMAT(TA_LocalTimestamp,`dd-MM-yyyy`,`ar`) AS Hijri, DATENAME(WEEKDAY, 
                      TA_LocalTimestamp) AS myday, MIN(CASE WHEN TA_IDContext = 100 THEN substring(CONVERT(VARCHAR, TA_LocalTimestamp, 114), 1, 5) END) AS min_in, 
                      MAX(CASE WHEN TA_IDContext = 200 THEN substring(CONVERT(VARCHAR, TA_LocalTimestamp, 114), 1, 5) END) AS max_out,TA_AccessPointID
 
  from TBST_TARecords
   WHERE    convert(varchar(11), TA_LocalTimestamp, 120) >= `2018-01-03`    and  convert(varchar(11), TA_LocalTimestamp, 120) <= `2018-01-31` and TA_UserID=`200` --TA_IDContext in(100,200) and
   GROUP BY TA_UserID,TA_UserFirstName + ` ` +TA_UserLastName, CONVERT(nvarchar(11), TA_LocalTimestamp, 120), CONVERT(nvarchar(10), TA_LocalTimestamp, 120), FORMAT(TA_LocalTimestamp,`dd-MM-yyyy`,`ar`), DATENAME(WEEKDAY, TA_LocalTimestamp),TA_AccessPointID
ORDER BY CONVERT(nvarchar(10), TA_LocalTimestamp, 120) DESC