Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Qualify object names on table valued function - bug

maddocmaddoc Posts: 8 New member
edited November 4, 2018 8:16AM in SQL Prompt
Hi,
When I'm qualifying object names (CTRL+B, CTRL+Q)
on query that has clause and table valued function with already qualified object names - table alias get removed, e.g:

SELECT      c.Res
FROM        person AS p
CROSS APPLY My_DB.dbo.fn_bla(p.column_name) AS c

Becomes:

SELECT      c.Res
FROM        person AS p
CROSS APPLY My_DB.dbo.fn_bla(column_name) AS c

Happens with all members of my team as well.
Using version 9.4.1

Thanks.

Tagged:

Answers

Sign In or Register to comment.