Options
Temp tables and Suggestions Not Showing
MikeyC
Posts: 249 Bronze 3
I am running SQL Prompt 4.0.4.14 and have found that in some cases suggestions aren't showing up for temp tables.
Given this code:
Backup_set_id isn't suggested but if you qualify the field with the alias like so:
You do get the suggestion.
Given this code:
SELECT Backup_set_id, MIN(first_family_number) AS F1 INTO #Test FROM msdb.dbo.backupfile D GROUP BY backup_set_id ORDER BY backup_set_id; SELECT * FROM #Test WHERE b<cursor>
Backup_set_id isn't suggested but if you qualify the field with the alias like so:
SELECT D.Backup_set_id, MIN(first_family_number) AS F1 INTO #Test FROM msdb.dbo.backupfile D GROUP BY backup_set_id ORDER BY backup_set_id; SELECT * FROM #Test WHERE b<cursor>
You do get the suggestion.
Comments
Cleveland, OH USA
They have a cumulative update that you can download from here. (Currently 4.0.4.19)
It looks like this is a bug with SQL Prompt 4. I have logged the case SP-2967.
Thanks for bringing it to our attention.