Support TSQL PIVOT Operator
Working with poorly designed SQL database with absolutely no normalization. Have many tables with repeating groups, ie: item1, item2, item3, item4, item5, etc. The TSQL Pivot operator allows me to turn a single row with 5 items into 5 rows. Then I could ForEach through the rows.