Aliases not working when setting variable

M. Haar

When you want to assign a value to a variable with the SET option then the the table name won't get an Alias.

Like:

DECLARE @PersonID INT

SET @PersonID = ( SELECT [Id] FROM [Dbo].[Person].....)

It would be great if automatic assigning of aliasses worked in these kind of situations as wel!

Aaron L

Hi M. Haar,

Thanks for your suggestion! Hopefully this is a simple improvement to make so I'll look into implementing it now

Aaron L

We've just released a Prompt 6.5 beta which I've included your suggestion in. You can find out more and download the beta from this forum post.

Please let us know if it works for you!

Aaron.

M. Haar

Hi Aaron Law,

Thanks for the quick response and even quicker resolution! I will install the update this evening and will let you know if that worked for me.

Marco.

M. Haar

Hi Aaron Law,

Just wanted to let you know the fix works!

Thanks!

Marco.

Aaron L

Awesome! Thanks Marco!