How can we help you today? How can we help you today?

Suggestion Order Changes

I am using SQL Prompt 4.0.3.12 and have noticed that the order of the suggestions changes when it shouldn't.

For instance try this: 
SELECT 
	*
FROM msdb.dbo.backupfile B
	INNER JOIN msdb.dbo.<cursor>

When you get the suggestions at this point the backupfile suggestion is all the way at the bottom of the table list, it is no longer in alphabetical order. It is very annoying that you can't predict where a suggestion is going to be.
MikeyC
0

Comments

1 comment

Sort by
  • Chris Auckland
    Thanks for your post.

    The reason the table is at the bottom of the list is because once you have referenced a table, SQL Prompt assumes that it's the last table you would want to reference again. I guess they didn't think about self joins :)

    I have logged this as a bug with SQL Prompt 4. Hopefully it will be addressed in a future version.

    For your reference the bug tracking code for this issue is SP-2882.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.