I type the following code to put data into a temp table. Then code complete
works for selecting the temp table, which is great.
Now I will add an alias to the temp table of “tt” and replace the
“*” with “tt.” so I can select fields from the temp
from #TempTable1 as tt
but I cannot get the fields to display from #TempTable1 after I type the dot or
if I force the list of fields.
I know this is possible as I use a third party add on that I use in SSMS that
does this nicely.
This is the one last things that is preventing me from moving from SSMS
completely as I can code much faster in SSMS with this add-on than I can in
Toad. So what I end up doing is typing the code in SSMS and then copying and
pasting into Toad.
Let me know if you need any further information.