What are the challenges you face when working across database platforms? Take the survey
Options

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.