Monday, January 28, 2013

SQL Server and PIVOT/UNPIVOT

http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

I think the syntax is somewhat confusing, but this thing can be handy.

Not all databases I encounter are normalized! In fact I see many tables that resemble spreadsheets (i.e. with many columns).