Qualify object names not working with temporary tables
JDS44
Posts: 8
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.
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.
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.
Comments
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.