by Emma Tsai
In my last blog, I talked about how to use PIVOT operator to group and aggregate data in SQL database. Today, I am going to share how to Un-pivot data.
The starting point is some pivoted data. I used a sample table called Sales.FreightTotals as an example. The sample data shows as below:
...

By Emma Tsai
Performing functional testing for software applications is part of the job as a business analyst. Occasionally, I need to work with SQL server to do database queries so that I can verify that the application pulls data results as expected. Recently, I learned how to use PIVOT operator to group and aggregate data in SQL database. Here is how it works:
In pivot queries, here are the thr...

By Kristi Feng
Several weeks ago Sheila showed how to transpose GLAFS from columns to rows.
Sometimes there is also a need to transpose rows to columns.  For example, we want to see item quantities for a year in a row we can use the following SQL with ICHIST table.
 
The following two Transact...

By Sheila Zhang
GLAFS table is my favorite data table in the Sage 300 ERP database. It was designed to list all fiscal periods of a fiscal year with 15 fields or columns. Here are two ways to transpose the period’s columns to rows.
Method 1:

Method 2:
...