What are the challenges you face when working across database platforms? Take the survey
Options

Temp tables and Suggestions Not Showing

MikeyCMikeyC Posts: 249 Bronze 3
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

  • Options
    meklemblmeklembl Posts: 107 Bronze 2
    SQL Prompt 4.0.4.14? The last I can find on your site is 4.0.3.12.
    Larry M
    Cleveland, OH USA
  • Options
    MikeyCMikeyC Posts: 249 Bronze 3
    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)
  • Options
    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
Sign In or Register to comment.