Assume that the only way you are able to get some data for analysis is in the form of the Excel spreadsheet pictured in Figure 3.5, which is obviously not normalized.
- 3. When You Can’t Change the Design
- from Effective SQL: 61 Specific Ways to Write Better SQL, First Edition
- Publisher: Addison-Wesley Professional
- Released: December 2016
Using UNION to Un-Pivotize Excel Data.
Share this highlighthttp://www.safaribooksonline.com/a/effective-sql-61/7570063/