BAQ / SQL Question

[josecgomez]

Trying to create a BAQ that lists sales by salesperson. Problem is SalesRepList can hold multiple. Help!

Here is a Basic BAQ which does this using a CTE (Give it a shot if you’d like) RepListFromIvcHead.baq (30 KB) (>10.2.100) with [SubQuery1] as (select [InvcHead].[Company] as [InvcHead_Company], [InvcHead].[InvoiceNum] as [InvcHead_InvoiceNum], [InvcHead].[SalesRepList] as [InvcHead_SalesRepList], (2) as [Calculated_num], ([Ice].entry(1 ,InvcHead.SalesRepList, '~')) as [Calculated_SalesRe] from Erp.InvcHead as InvcHead union all select [SubQuery1].[InvcHead_Company] as […