Given this code:
SELECT DISTINCT
*
INTO #Test
FROM MASTER.dbo.spt_values
SELECT *
FROM #<cursor>
SQL Prompt 3.8.0.244 will not have #Test as a suggestion. If you remove DISTINCT it will. Then once you have removed it, you can put it back and it will still have it as a suggestion. (I don't really like having to go through and remove code and put it back so SQL Prompt can work.)
Michael
SELECT DISTINCT
*
INTO #Test
FROM MASTER.dbo.spt_values
SELECT *
FROM #<cursor>
SQL Prompt 3.8.0.244 will not have #Test as a suggestion. If you remove DISTINCT it will. Then once you have removed it, you can put it back and it will still have it as a suggestion. (I don't really like having to go through and remove code and put it back so SQL Prompt can work.)
Michael