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

unresolved alias - except rename alias works?

I'm trying to expand a wildcard on a multiply nested query (quite long, have already bumped the parserlookaheaddistance to 30000). Anyway SQLprompt has a popup saying unresolved alias but at the same time I can click on the alias from select clean.* from and re-name alias works correctly for the subquery alias and WHERE items associated with it.
Any ideas what I've broken?
 I've refreshed suggestions, installed prompt version and I'm using ssms 18.6 (15.0.18338.0) against a database in sqlserver 19 (15.0.2000.5).  The query runs fine... just prompt not being as helpful as usual.  It does offer to expand other standalone queries in this same file so not totally broken
Sign In or Register to comment.