Run query against multiple databases

[katehol]

I have to run a script I have written against multiple databases (about 40) - how would I do this? Once I have the results I need them all to be unioned into one table.

Part of the script is below...

Thanks for any help.

USE db1

SELECT * FROM Users
WHERE (Users.user_type = '1.0' AND Users.user_id <> 'itadmin')
OR (Users.user_id LIKE '%test%' OR Users.user_forename LIKE '%test%' OR Users.user_surname LIKE '%test%')

 

[SQLBill]

For a start, take a look at FAQ183-4107

-SQLBill

Posting advice: FAQ481-4875

 

[katehol]

Thanks for that - am now a bit further on... Have got it all working to bring back the individual results, but how can I union all of those results together?
Thanks
K