How can we help you today? How can we help you today?

Suggestions not showing up in UPDATE with EXISTS queries

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

enrico_fraccon
0

Comments

5 comments

Sort by
  • 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
    0
  • 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!
    Jessica R
    0
  • enrico_fraccon
    Hi, is there any news about the hypothetical fix?

    Thanks and kind regards
    enrico_fraccon
    0
  • Jessica R
    Hi Enrico,

    Not yet I'm afraid, but I'll post here once we have a meaningful update.
    Jessica R
    0
  • 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.
    Tom_C
    0

Add comment

Please sign in to leave a comment.