Fix pagination in Microsoft SQL Server when using alias columns

• Type: Regression Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.1.2, 5.2.3, 6.0.5 GA
• Fix Version/s: --Sprint - SP, 6.0.6 GA, 6.1.0 CE RC1
• Component/s: Environments > Databases
• Labels: None
• Branch Version/s:
  6.0.x, 5.2.x, 5.1.x
• Backported to Branch:
  Committed

In SQL Server 2008, even though ORDER BY recognizes column aliases, OVER(ORDER BY) does not. As a result of LPS-9903, pagination does not work if the ORDER BY uses column aliases.