Update Query for Microsoft SQL Node

I have a node running a update query to my database. Currently we have it setup to execute 1 item at a time on a loop because it seems we are not able to send more than row of data at a time. When trying to send more than one item it does not iterate over the entire list of items. Is this intentional or is there a work around for this?

Hey @Nostalgic,

Looking at the Looping docs the MSSQL node is one of the ones that doesn’t loop internally so you would need to use a split in batches node to build out the loop manually until we do an overhaul on the node.