Title: storeProcedure sql server hijri dates                                 If you need copy same format use firefox or chrome or safari but iexplorer not work


Preview of Code
    select TA_UserID,convert(varchar, TA_Timestamp, 108) as time,TA_UserFirstName,TA_UserLastName,CASE DATENAME(dw,TA_Timestamp)
                when `saturday` then `السبت` 
                when `Sunday` then `الاحد`
                when `monday` then `الاثنين`
                when `tuesday` then `الثلاثاء` 
                when `wednesday` then `الاربعاء` 
                when `thursday` then `الخميس` 
                when `friday` then `الجمعة`
                 END as Days ,FORMAT(TA_Timestamp,`dd/MM/yyyy`,`ar`) AS Hijri,convert(varchar(11), TA_Timestamp, 103) AS Gregorian, 
   CASE TA_IDContext
        WHEN 100 THEN `دخول`
        WHEN 200 THEN `خروج`
        WHEN 0 THEN `admin`
    END as inout,TA_AccessPointID,
     CASE TA_AccessPointID
                when `1801B15B0016A700` then `3D_الامين` 
                when `D201B15A00163A00` then `3D_بوابة2`
                when `0601B17900169400` then `3D_تجهيزات`
                when `5901B15200161600` then `3D_الحاسب` 
                when `0F01B15B00167900` then `3D_الحركة` 
                when `1C01B15A0016B600` then `3D_مالية` 
                when `FB01B15A00161A00` then `3D_مصعد`
                when `5501B18200163500` then `3D_موظفيين`
                when `F901B15200164A00` then `3D_الخدمات`
                when `EA01DFEE00170800` then `3D_صحة`
                when `1F01DF7A00173900` then `3D_الاراضي`
                when `1301DFD500171800` then `3D_صيانة`
                when `0601DFEF00179100` then `3D_نسائي` 
                when `2901DFA400179A00` then `3D_الفنية`
                when `A501DF9100175B00` then `3D_عمراني`
                when `8901DF8300176F00` then `3D_البلديات`
                when `C101DF9100174400` then `3D_المختبر`
                when `1401DFEF0017A400` then `3D_الاسواق`
                when `7701DFC200172A00` then `3D_الترفيعات`
                when `0A01DFCE0017D900` then `3D_الزراعة`
                when `AC01DF910017CD00` then `3D_الاستثمار`
               when `9701DF910017D800` then `3D_صناعية`
                when `1801DF7A0017BC00` then `3D_بلاغات`
                when `FE01DFB30017F600` then `3D_معلومات`
                when `D201B15200160400` then `3D_engineer`
                  END as Devices
                   
   from TBST_TARecords
   WHERE TA_UserID LIKE `1218` and (TA_Timestamp >= CONVERT(datetime, `01/05/1438`,131)+1) AND (TA_Timestamp <= CONVERT(datetime, `30/05/1438`,131) + 2)
    order by TA_Timestamp desc