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

Latest Update

mckmck Posts: 1 New member
Latest update is breaking the code using Format SQL
JOIN [dbo].[Location] AS [l]
ON [ld].[LocationId] = [l].[Id]
CROSS APPLY [dbo].[GetLocationAndChildren]([l].[Id]) AS [t]

changes to 
JOIN [dbo].[Location] AS [l]
ON [ld].[LocationId] = [l].[Id]
CROSS APPLY [dbo].[GetLocationAndChildren]([Id]) AS [t]

It removes alias within the function parameter causing Ambiguous column name 'Id'.

Tagged:

Answers

Sign In or Register to comment.