Update SQL Table of multiple rows with different identifiers

[Kimo]

Nevermind. Thank you for replying. I have managed to solve this. Everyone have same application can refer to this post below. Thank you

How to update SQL query with an identifier has 2 strings

that is not what I said to do... e.g.. const array = flow.get('array'); //example ["A1", "A2"]; if(!array || !array.length) { node.warn("array is empty"); return null // halt flow } const whereClause = "(" + array.map(e => "'" + e + "'").join(",") + ");" const now = new Date().toLocaleString("en-GB"); msg.payload = "UPDATE [dbo].[Background] SET [Start_Time] = '" + now + "' WHERE [Name] in " + whereClause; return msg;