Hello FM community,
I have some remaining data that I need to import into my solution. I have a query that I use from the Import Records > ODBC Data Source that connects to SQL Server but since the query is so large I run it in batches based on either year or between dates. Is there a way that I can automate this process to go do a list of years(?) or dates(?) so that FileMaker can import the data a bit more efficiently, rather than having me alter the query each time it completes?
Additional information: the SQL server query performs a concatenation on two columns into one field and is able to concatenate multiple of these, delimited by a comma for each unique id.
Thanks in advance!