string pronadji = "SELECT p.brojprijavnice2 AS Redni broj, p.radnik AS Radnik, p.vrijemeprijave AS Vrijeme Prijave, p.vrijemeodjave AS Vrijeme odjave," + "CASE WHEN (DATEDIFF(SECOND, p.vrijemeprijave, p.vrijemeodjave) / 3600) > 8 THEN 8 ELSE(DATEDIFF(SECOND, p.vrijemeprijave, p.vrijemeodjave) / 3600) END AS Radni_sati, + "CASE WHEN(DATEDIFF(SECOND, p.vrijemeprijave, p.vrijemeodjave) / 3600) > 8 THEN(DATEDIFF(SECOND, p.vrijemeprijave, p.vrijemeodjave) / 3600) - 8 ELSE NULL END p.prekovremeni AS Prekovremeni," + "FROM dbo.prijava_radnika p WHERE vrijemeprijave >= convert(date, getDate()) and vrijemeodjave >= convert(date, getDate()) and status = 'odjavljen'";
END p.prekovremeni Prekovremeni
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)