WHERE EXISTS (SELECT * FROM [Worker] AS [Worker] WHERE [Worker].[Id] = [CurrentMonthWork].[refWorkerId] ANDdbo.GetMonthString(@Worker_parCurrentDate, 0) = dbo.GetMonthString([CurrentMonthWork].[FinishDate], 0) AND ( ([Worker].[IsActive] = @Worker_parIsEmployed)));
What is the situation? Multiple relationship keys?
yes , the datastructure has two relationship.
But this problem seems to be caused by 1 relationship having 2 keys, is this correct?
A relationship based on two calculated fields!
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.