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

SQL Prompt V 9.3.0.6627 is removing aliases from columns during format

SQL Prompt is removing already assigned aliases if the column is used in an inline table valued function and the column exists in multiple tables used in the query. The result is query is failing since the column cannot be resolved anymore.

like it changes 
FROM [master].[dbo].[sp_GetColumnType]([c].[name], [c].[max_length], [c].[precision], [c].[scale], [c].[collation_name], [db].[collation_name]) )COLLATE SQL_Latin1_General_CP1_CI_AS AS [ColumnDef]
to
FROM [master].[dbo].[sp_GetColumnType]([name], [max_length], [precision], [scale], [collation_name], [db].[collation_name]) )COLLATE SQL_Latin1_General_CP1_CI_AS AS [ColumnDef]
(see attached)
gvarol
0

Comments

4 comments

Sort by
  • Russell D
    We're looking into this.
    Russell D
    0
  • rfarris2000
    I'm seeing the same thing...
    rfarris2000
    0
  • cmfox1970
    Any progress on this?
    cmfox1970
    0
  • maddoc
    Any new on that?
    maddoc
    0

Add comment

Please sign in to leave a comment.