Temp tables and Suggestions Not Showing

CodantiMCodantiM Posts: 245
edited May 12, 2010 3:13PM in SQL Prompt Previous Versions
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.

Comments

Sign In or Register to comment.