Inserting multiple rows via SQL Connector

[mishav]

Hey Marc,

I think Insert into … values ( SELECT … FROM … ) would suit, given your low number of records.

To help construct it, these other posts I made earlier might help …

SQL db connection made, won't return values. Please help

For exact match, need to convert Bubble’s type “text” to “varchar” … select top 200 * from CRM where phone = CONVERT(VARCHAR,@phone) order by name

SQL Database Connector

How about put the params in a one-row derived table, and cross join it to Reporting? Example: select thingy from Reporting, (? orgname, ? periodtype, ? reporttype, ? datestart) myparams where organisation_name = orgname and blah blah and datereported between (case blah blah date_add(datestart, interval blah If things get too complex, can put them into a stored procedure instead.

If it wasn’t 1am I might be tempted to play with it more …