Forum Discussion

EaglesTony's avatar
EaglesTony
Post Prodigy
2 years ago

How do I check a column in a table in a SQL query

Hi,     I currently have the following (which works): = Sql.Database("Northwest", "Reporting", [Query="SELECT DISTINCT SUBSTRING([IssueKey],1,(CHARINDEX('-', [IssueKey])-1) ) AS TeamProject#(lf)FR...
Need Help
ToddChitt's avatar
ToddChitt
Super User
2 years ago

Check your query syntax. In the below setup, probably similar to yours, I have Query1, which is simple text that will get turned into a SQL SELECT statement. It concatenates Parameter1, which has a Current Value of FooBar. The evaluation of the concatenation is displayed for Query1, and just by looking at it I can see that, as is, it would fail if I tried to execute it against a SQL database. Why? Because the Parameter value is of type string and NOT enclosed in single quotes. 

 

For you, copy the contents of the Query text and paste it into something to execute against the database. That may give you a clue.

 

 

  • EaglesTony's avatar
    EaglesTony
    Post Prodigy
    2 years ago

    I have Parameter1 as :

    CurrentSprintInfo[PriorSprintStartDate]{0}

     

    but now an error "Expression.SyntaxError: Token ',' expected."

     

    I have the end as :

     

    WHERE SprintStartDate = " & #"Parameter1")]