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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 546782 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 4/1/2010 12:25:58 AM
Access Restriction Public


"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.
Sign in to post a comment.
Posted by Microsoft on 5/27/2010 at 2:02 PM
Closing the bug as explained before.

Posted by Microsoft on 5/26/2010 at 12:36 PM
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.

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

I'm also interested in this. Any status yet?
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