ORDER BY suggestions do not include SELECT aliases

SQL Prompt 4.0.4.11 doesn't suggest aliases defined in the SELECT portion of a query in the ORDER BY portion.

SELECT
	'Test' AS Field1
ORDER BY
	&lt;cursor&gt;

With the above query "Field1" should be listed as a suggestion.

Same applies when coming from a table:

SELECT
	backup_set_id AS Alias1
FROM msdb.dbo.backupfile
ORDER BY
	&lt;cursor&gt;

With the above query "Alias1" should be listed as a suggestion.

MikeyC February 26, 2010 19:42

2 comments

Apologies for inconvenience caused.

I have logged this in our internal tracking system whose id is SP-1911.

It will be reviewed for a future release of SQL Prompt although we have not timescales for this at present.

Kindly let us know if you have any issues or questions regarding the product,I'll like to help.

Anu D March 01, 2010 06:33

0
Can I assume by the SP number that this issue has been logged for a very long time and hasn't been added through a number of versions of SQL Prompt?

MikeyC March 02, 2010 16:05

0

Please sign in to leave a comment.

How can we help you today?