Forum Discussion

joshhansen29's avatar
joshhansen29
Frequent Visitor
6 years ago

Create SQL query from string in multiple rows.

Hello All,   I realize that this might not be the best approach to doing this, but I was hoping to see if it's possible. Overall Objective: I'm trying to use power query to generate a list of all ...
Need Help
dax's avatar
dax
Community Support
6 years ago

Hi joshhansen29, 

I am not clear about your requirement, if possible, could you please explain "I can copy the text from the Query column and paste it in as the SQL statement that will generate what I'm looking for, but it is now a static query that will not bring in new Stored Procedures that are created without manually updating the query." to me? Whether you could use query to get this value directly?

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • joshhansen29's avatar
    joshhansen29
    Frequent Visitor
    6 years ago

    Hello,

    What I meant was that I can copy the entire column (Circled in red)

     

    Then I can paste the text into the SQL Statement (Circled In blue) of the source of another query. 

     

     

    I'm essentially using power query to write the text of another SQL query. I was just hoping that there is a way to do that directly without having to manually copy the generated text and paste it into the new query.

     

    Does that make sense? 

    Thanks!

    Josh