12/7/2023 0 Comments Time attendance calculator, RowNum = ROW_NUMBER() OVER (PARTITION BY t.UserID, r.Checktime ORDER BY 1/0)ĪND DATEADD(dd, 0, DATEDIFF(dd, 0, t.Checktime)) = DATEADD(dd, 0, DATEDIFF(dd, 0, t2.Checktime)) , = CAST(DATEDIFF(MINUTE, t.CheckIn, t.CheckOut) / 60. , CheckOut = CONVERT(VARCHAR(10), t.CheckOut, 108) , CheckIn = CONVERT(VARCHAR(10), t.CheckIn, 108) , = DATEADD(dd, 0, DATEDIFF(dd, 0, t.CheckIn)) INSERT INTO (UserID, Checktime, CheckStatus)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |