Suggestions not showing up in UPDATE with EXISTS queries

enrico_fraccon

SQL Prompt version: 10.6.13.20795
SSMS version: 18.9.1

I have a query which needs to update the records of the table IMP_MISSIONI_TRASFERIMENTO (imt) where exists a record on the table SALDI_DETTAGLIO (sd) with a certain condition. When inside the exists, SQL Prompt does not suggets the columns of "imt":



But it will show them on an UPDATE with INNER JOIN or in a select with the same condition:




At the same time, if i write only the column name, it suggests the "imt" alias, so i think it should appear on the the suggestions when i write "imt."


Do you know if there is a settings which allows me to make it show the suggestion or if it's a bug?

Thank you and kind regards,
Enrico

Tom_C

Hi Enrico,

Apologies for the delay in providing you with an update, our dev team have addressed this issue in yesterday's release.
https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-10-release-notes

Please let us know if any further issues post update.

Jessica R

Hi @enrico_fraccon!

I am able to reproduce this, please bear with me while I look into it.

Kind regards,

Jessica Ramos

Jessica R

Quick update: SQL Prompt should be making suggestions here but the problem appears to be specific to the alias (without the AS imt, it makes suggestions as expected). We are still investigating, please continue bearing with us!

enrico_fraccon

Hi, is there any news about the hypothetical fix?

Thanks and kind regards

Jessica R

Hi Enrico,

Not yet I'm afraid, but I'll post here once we have a meaningful update.