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

Temp tables and Suggestions Not Showing

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: 
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.
MikeyC
0

Comments

3 comments

Sort by
  • meklembl
    SQL Prompt 4.0.4.14? The last I can find on your site is 4.0.3.12.
    meklembl
    0
  • MikeyC
    meklembl wrote:
    SQL Prompt 4.0.4.14? The last I can find on your site is 4.0.3.12.

    They have a cumulative update that you can download from here. (Currently 4.0.4.19)
    MikeyC
    0
  • Chris Auckland
    I am running SQL Prompt 4.0.4.14 and have found that in some cases suggestions aren't showing up for temp tables.

    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.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.