Possible SQL Complete Bug in 3.5.51

awatson · Post by **awatson** » Tue 07 Feb 2012 15:41

Since upgrading to 3.5.51 I have noticed what appears to be a bug. When working with a statement I have used EXEC to populate are local variable. It seems that in SELECT statement that include JOINS of any kinds that SQL Complete does not function with the table alias if the statement occurs after the EXEC.

When doing the JOIN the table is aliased but when setting the ON the alias does not appear in the context and does not appear to be recognized. If the same SELECT statement is moved above the EXEC it works properly.

This happens in SSMS for 2008R2.

alexa · Post by **alexa** » Tue 07 Feb 2012 16:29

Hello,

We're aware of the problem and will fix it in one of the next builds.

Currently, to workaround this issue, we suggest you to put ; or the GO command at the end of every statement.

So in your case you would need to put ; or the GO command at the end of the EXEC statement.