Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

UNION Help Expand / Collapse
Posted Tuesday, September 11, 2012 8:09 AM



Group: General Forum Members
Last Login: 2 days ago @ 11:26 AM
Points: 7,502, Visits: 8,651
Eugene Elutin (9/11/2012)
Actually the attribute splitting may not be a flaw, but done on purpose. One of the common places where you can see this kind of picture is data warehouses (non-conformed dimensions).

Or companies that vend solutions to multiple customers and can't mix their data for legal reasons. Like health insurance software companies that host the data on site. I actually worked for one of those.

Of course, in that instance, any request to mingle the data via UNION (at least in the U.S.) would be a Bad Idea.

Brandie Tarvin, MCITP Database Administrator

LiveJournal Blog:
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1357444
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse