Timeline for Looking for advice on how to integrate data from 100+ client DB's into a centralized reporting database
Current License: CC BY-SA 3.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 29, 2017 at 16:51 | comment | added | bperry | Is there a more elegant way to set up those views besides something like... SELECT Field1, Field2, Field3 FROM [Database1].[schema].[TableName] UNION ALL SELECT Field1, Field2, Field3 FROM [Database2].[schema].[TableName] | |
| Jun 29, 2017 at 14:35 | history | answered | David Browne - Microsoft | CC BY-SA 3.0 |