Latest Update
mck
Posts: 1 New member
in SQL Prompt
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'.
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