Custom Alias not incremented if used more than once
cwallis
Posts: 6
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
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
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.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
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.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com