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
EaglesTony's avatar
EaglesTony
Post Prodigy
2 years ago

There is only ever one row in the CurrentSprintInfo table.

  • PawelWrona's avatar
    PawelWrona
    Resolver II
    2 years ago

    So, you should do the following:

    = Sql.Database("Northwest", "Reporting", [Query="SELECT DISTINCT SUBSTRING([IssueKey],1,(CHARINDEX('-', [IssueKey])-1) ) AS TeamProject#(lf)FROM [Reporting].[dbo].[SprintIssuesSummaryEOS] WHERE Sprint IN#(lf)(SELECT Sprint#(lf)FROM dbo.SprintDates#(lf)WHERE SprintStartDate = " & CurrentSprintInfo[PriorSprintDate]{0} & " and SprintEndDate = " & CurrentSprintInfo[PriorSprintEndDate]{0} & ")"

     

    If all the naming I used is correc,t this should work right away.