How can we help you today? How can we help you today?

Qualify object names not working with temporary tables

If the snippet below is run through SQL Prompt 6.2.0.366's Qualify Object Names process it highlights the two table names and the column name with unable to resolve errors.

CREATE TABLE #OverrideMonth (OverrideMonth INT)
       
SELECT OverrideMonth FROM #OverrideMonth om


Is this expected behavior?

If so is there any good way to see the list of items that have problems that I can maintain since I working on a 3000 line procedure that when I edit it to manually fix them all the underlined issues dissapear and I have to re-run and re-find the areas to hand fix.
JDS44
0

Comments

1 comment

Sort by
  • Aaron L
    Hi JDS44,

    This looks like a bug to me, thanks for reporting it. I found a similar issue in our bug tracking system as SP-3198 which has been around for a while unfortunately. We have some work planned on revamping the qualify object names feature for the next version of SQL Prompt and I'll make sure that this gets fixed as part of that.

    Aaron.
    Aaron L
    0

Add comment

Please sign in to leave a comment.