Sorry for bothering once again today. I have a pertty straight forward question/problem: Is the Microsoft SQL node not capable of being called multiple times?
I have this very simple Function that generates 2 items. But the Microsoft SQL only returns a result for the first item. It is not called the second time. Is this my fault or is the node having some issue?
Ah yes you are sadly correct. It looks like it got implemented wrongly and it executes only once. We have to fix that in a future version of the node (changing it now could break the workflows of people). So what you would have to do for now is to use the SplitInBatches node set to 1 and then iterate with it over the items.
It is not something I have seen on the immediate roadmap, It can be done with the split in batches node at the moment though so it can be worked around.