Set a Variable in Edit Script

[Anonymous]

How do I set a variable equal to the results of a SQL query?

for example let x = select dbname from table

[#2 · Accepted solution]

You can do it otherway, store the sql query output in table and after that, using peek function you can assign it to any variable.

SQLTableList:

          LOAD Name as TableNames;

          SELECT Name From AdventureWorksDW2008R2.sys.tables;

let vMyTableName = Peek('TableNames',0,'SQLTableList');

Hope this helps.