Temp tables and Suggestions Not Showing

MikeyC

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.

meklembl

SQL Prompt 4.0.4.14? The last I can find on your site is 4.0.3.12.

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)

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.