Execute SQL Statement: variable from two different server into a sql query
Hello everyone, I am facing a problem.
I have two sql connections (two different server). I execute one query in the first connection and save the data in a variable (%QueryResult%). In the second connection I do another query but I want to put data from the first connection %QueryResult% into my sql query, but the result is always nothing.
Select * From Tabel1 Where List in (%QueryResult%)
QueryResult = Datatable :
When I do it directly in MS SQL Server Management Studio i would usually type in
Hi, I think the issue you faced was the conversion between variable types, can you click on the %QueryResult% in variable pane while the process was executed and post the screen capture so I can help you sort things out ?