Click here to Skip to main content
15,909,591 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
New line in constant? Try on one line, and using \ @ but not succes ...help...thank you

What I have tried:

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'";
Posted
Updated 13-Mar-18 10:45am

string pronadji =
@"select
p.brojprijavnice2 [Redni broj],
p.radnik Radnik,
p.vrijemeprijave [Vrijeme Prijave],
p.vrijemeodjave [Vrijeme odjave],
CASE WHEN (DATEDIFF(SECOND, p.vrijemeprijave, p.vrijemeodjave) / 3600) > 8
THEN 8
ELSE(DATEDIFF(SECOND, p.vrijemeprijave, p.vrijemeodjave) / 3600)
END 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 Prekovremeni
FROM
dbo.prijava_radnika p
WHERE
vrijemeprijave >= convert(date, getDate())
and vrijemeodjave >= convert(date, getDate())
and status = 'odjavljen'";
 
Share this answer
 
Comments
Goran Bibic 13-Mar-18 16:45pm    
Thank you...Regards
Solved....Thank you...problem is

END p.prekovremeni Prekovremeni
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900