SQL Syntax Error

Question

I'm getting an incorrect syntax error when I try to execute this query in t-sql. I'd appreciate any help - I believe the issue is on, or around the ROUND statement.

SELECT
    EMPL.employeeid as KEmplID,
    EMPL.PERSONNUM as EmployeeNumber,
    EMPL.PERSONFULLNAME as FullName,
....

FROM
    VP_EMPLOYEE as EMPL,
    VP_PERSON as PRSN,
    (
    SELECT
        TLS.employeeid as EMPLID,
        TLS.applydate as APPLYDATE,
        ROUND((SUM(CONVERT(FLOAT,TLS.timeinseconds)) /60/60,1)) AS ElapsedHrs

    FROM
        VP_TOTALS as TLS,
        VP_PAYCODE as PAYCODE



....

I am just not quite sure where my issue stems - again, I think it is the round statement but I could be wrong. I will appreciate any and all help - or suggestions - to make this more efficient or help with the rounding, conversion and sum of the data.

FROM VP_EMPLOYEE as EMPL, VP_PERSON as PRSN, - doesn't make sense — Simcha Khabinsky
– Simcha Khabinsky, Commented Jun 11, 2014 at 18:49

Kermit · Accepted Answer · 2014-06-11 19:02:47Z

3

Incorrect:

ROUND((SUM(CONVERT(FLOAT,TLS.timeinseconds)) /60/60,1)) AS ElapsedHrs

Corrected (parenthesis placement):

ROUND((SUM(CONVERT(FLOAT,TLS.timeinseconds)) /60/60),1) AS ElapsedHrs
                                                   ^

edited Jun 11, 2014 at 19:02

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

answered Jun 11, 2014 at 18:53

Steven

13.9k27 gold badges105 silver badges152 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Syntax Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related