sQL invalid column name on alias code example
Example: invalid column name sql
Whenever this happens to me, I press Ctrl+Shift+R which refreshes intellisense, close the query window (save if necessary), then start a new session which usually works quite well.