Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
SELECT Datum, BeginnZeit, KundeID, MitarbeiterID, EndZeit, AuftragID, Tätigkeit, Bemerkungen, DATEDIFF(n, BeginnZeit, EndZeit) / 60 AS Stunden,
SUM(DATEDIFF(n, BeginnZeit, EndZeit) / 60) AS Summe
FROM dbo.Zeit
GROUP BY Datum, BeginnZeit, KundeID, MitarbeiterID, EndZeit, AuftragID, Tätigkeit, Bemerkungen, DATEDIFF(n, BeginnZeit, EndZeit) / 60
HAVING (Datum = { fn CURDATE() })
SELECT SUM(Gehalt) FROM Mitarbeiter