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 :
Name111
Name112
Name113
Name114
When I do it directly in MS SQL Server Management Studio i would usually type in
Select
*
From
Tabel1
Where
List in
('Name111',
'Name112',
'Name113',
'Name114')
Do some have a solution?
