Home Dashboard Directory Help
Search

SQL Server Upgrade Advisor: Column aliases in ORDER BY clause cannot be prefixed by table alias by Vidhya_Pande


Status: 

Closed
 as Won't Fix Help for as Won't Fix


2
0
Sign in
to vote
Type: Bug
ID: 546782
Opened: 4/1/2010 12:25:58 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

"Column aliases in ORDER BY clause cannot be prefixed by table alias"

This issue is not detected and given in the report if this issue is in "View". It detects when it is in Stored Procedure.
Details
Sign in to post a comment.
Posted by Microsoft on 5/27/2010 at 2:02 PM
Closing the bug as explained before.

--
Umachandar
Posted by Microsoft on 5/26/2010 at 12:36 PM
Hi,
After further investigation/analysis, the behavior change associated with this rule happened in SQL Server 2005. And since we will not be supporting upgrading from SQL Server 2000 to new version in the next major version of SQL Server, this rule will not exist in the new upgrade advisor. As to the current versions of Upgrade Advisor (2005/2008), this fix doesn't meet the bar for cumulative update so we cannot address it there also. Sorry for the trouble and we will update you if anything changes on our end.

Thanks
Umachandar
Posted by John Chantha on 5/6/2010 at 8:38 AM
Hi

I'm also interested in this. Any status yet?
Thanks,
Posted by Microsoft on 5/4/2010 at 7:14 PM
Hi Vidyadhar,
Thanks for reporting the issue. We will investigate it and decide on how to address it best.

--
Umachandar, SQL Programmability Team
Sign in to post a workaround.