I need a loop for importing multiple DBs in SQL Server
Below is a simplification of what I'm trying to do. My XXX table would be a sql statement for a master list of all DBs. I would cycle through that and concatenate a master table. Can someone please help me!!!!
XXX: LOAD * Inline[X Sales.BiZ1
foreachxinXXX SQL SELECT * FROM [InsideTSQL2008].$(x); next;