Exporting normalized relational data from database to flat file

home
database
view story

1 Kicks

Exporting normalized relational data from database to flat file(omaralzabir.com)

submitted by oazabir(1805) 1 year, 8 months ago

Sometimes you need to export relational normalized data into flat files where a single row comes from various tables. For example, say you want to export all customer records along with their work and home address, and primary phone number in a single row. But the address and contact information are coming from different tables and there can be multiple rows in those table for a single customer. Sometimes there can be no row available in address/phone table for a customer. In such a case, neither INNER JOIN, nor LEFT JOIN/OUTER JOIN will work. How do you do it? Solution is to use OUTER APPLY.

add a comment |category: Database |Views: 6
Tweet