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

Custom Alias not incremented if used more than once

Hi

We have defined Custom Aliases for our tables, but if we use a table more than once in a query each subsequent tables alias does not get incremented:
SELECT *
FROM dbo.DimSectionFlat dsf
INNER JOIN dbo.DimDate dd
ON dsf.ExpiryMonth = dd.ExpiryMonth
INNER JOIN dbo.DimDate dd

If we let SQL prompt generate the alias then it works as expected:
SELECT *
FROM dbo.sysjobs s
INNER JOIN dbo.sysjobs s2

We have also gone back and checked SQL Prompt 3 and it works as expected, incrementing the Custom alias by 1 each time the same table is added.

Cheers
Chris
cwallis
0

Comments

2 comments

Sort by
  • Anu D
    Apologies for the inconvenience caused and thanks for your post Chris.

    I have logged this issue in our internal tracking system whose tracking id is SP-2953.

    Our developers are looking into this and I will update you as soon as it is fixed.

    Kindly let us know if you have any other issues or questions regarding the product,I'll like to help.
    Anu D
    0
  • Anu D
    Many thanks for your patience regarding this issue.

    I am pleased to inform you that we have fixed the SQL Prompt issue you were experiencing in our latest patch.

    Kindly check the forum post to download the version: https://www.red-gate.com/messageboard/v ... hp?t=10248

    Please let us know if this fixes your issue.
    Anu D
    0

Add comment

Please sign in to leave a comment.