BPM enquiry

[josecgomez]

Full Analysis of Why

Joining "TT" records to regular DB records in BPMs

Ran it in 10.2.100.5 with the Same Results First Test: [image] Ran SQL Profiler Yielded the following SQL Statement SELECT 1 AS [C1], [Extent1].[Company] AS [Company], [Extent1].[ABCCode] AS [ABCCode] FROM [Erp].[ABCCode] AS [Extent1] WHERE ([Extent1].[Company] IN (N'',@p__linq__0)) Note that the above SQL yields 1 record per each entry in ABCCode table for the given Company As a test I decided to create a variable which holds the current ttABCValue [image] Then …