Im trying to query across 2 databases and I keep getting the below error
Conversion failed when converting the nvarchar value '1449763,1449995,1450294,1520133' to data type int.
In my query39 I have:
select * from dbo.CENLOGHISTORY where SERIALNUM = {{query40.dataArray['0'].SERIAL_NUM_MAIN}}
I've also tried:
select * from dbo.CENLOGHISTORY where SERIALNUM = {{query40.data}}
In my query 40 I have:
select SERIAL_NUM_MAIN from dbo.lock
"SERIAL_NUM_MAIN" is a "numeric" in my SQL database. I've also tried doing it under nchar(10) and I get the same failing result.
Can someone advise what i am doing wrong? Thank you