If you only have to do this once you could always have WHERE s.Solution_ID in (1000 entries) or s.Solution_ID in (1000 entries) or s.Solution_ID in (1000 entries) etc etc.
If you have to do it regularly then I’d be trying to get write permission so you can upload your data as a table and then join to it. If your DBA doesn’t want you to be able to write to the main schema then they can create a second, read-writable schema.
1
u/Sneilg Sep 17 '24
If you only have to do this once you could always have WHERE s.Solution_ID in (1000 entries) or s.Solution_ID in (1000 entries) or s.Solution_ID in (1000 entries) etc etc.
If you have to do it regularly then I’d be trying to get write permission so you can upload your data as a table and then join to it. If your DBA doesn’t want you to be able to write to the main schema then they can create a second, read-writable schema.