This content has been marked as final. Show 3 replies
Hi, I have an issue in loading multiple SQL DB.
First, I'm loading the list of the companies:
SQL SELECT COMP_NAME, LANG
The table looks like this:
now I would like to load each company's data which is located in the company's Database (the name of the database is the content of the COMP_NAME i.e, Company_1, Company2_Comapny_3 etc so the name of the Database shoud be Company_1.dbo.'table name').
I will appreciate your help on how to create a loop which will run on the SQL SELECT and will load all the companies data.
Thanks in advanced.