Custom Alias not incremented if used more than once

cwalliscwallis Posts: 6
edited May 24, 2010 11:24AM in SQL Prompt Previous Versions
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

Comments

  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.