I have an sql query as show below. I would like to know how I can loop through a list of users and run this query per user.
I have code connecting to a single db but have never done so using multiple dbs.
Any help greatly appreciated.
The fact that the query is pulling from multiple databases doesn't matter. It's a single query, returning a single result set. If you already have code that can connect to a database, then that same code should work for this, provided all the back-end permissions are correct.
You must be logged in to reply to this topic.