Forum Discussion

Dwivedi15's avatar
Dwivedi15
Icon for Helper I rankHelper I
1 year ago
Solved

Syntax issue while connecting SQL server

After doing a direct query on a database :   -- POPULATE PROJECT REFERENCE AND TOTAL WATER OFFERED -- WITH WaterOffered AS ( SELECT Project_Reference, SUM(Water_Total_AV) AS Total_Water_Offer...
Need Help
  • Fowmy's avatar
    Fowmy
    1 year ago

    Dwivedi15 
    Connect to the SQL server through SSMS or Azure Data Studio and paste this query and ensure it runs without error, it will highlight the lines where you find errors.

  • MattiaFratello's avatar
    MattiaFratello
    1 year ago

    Remove ; at the end of your query

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
1 year ago

Dwivedi15 

Review your semi colons and proper use of schema.


Dwivedi15's avatar
Dwivedi15
Icon for Helper I rankHelper I
1 year ago

Do you have any idea from where can i check it ?

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    1 year ago

    Dwivedi15 
    Connect to the SQL server through SSMS or Azure Data Studio and paste this query and ensure it runs without error, it will highlight the lines where you find errors.

    • Dwivedi15's avatar
      Dwivedi15
      Icon for Helper I rankHelper I
      1 year ago

      I have ran this query in SSMS - no errors - ran successfully there 

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    1 year ago

    Dwivedi15 

    Try to add a semicolon (;) before WITH WaterOffered AS (


    ;WITH WaterOffered AS (

    • Dwivedi15's avatar
      Dwivedi15
      Icon for Helper I rankHelper I
      1 year ago

      No not worked -- now its giving this error :
      Microsoft SQL: Incorrect syntax near ';'. Incorrect syntax near ')'.