BAQ ~List~ handling

[jbooker (Josh Booker)]

InvcHead SalesRepList example:

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

With MSSQL 2016+ you can cross apply string_split like so (remove ordinal for better perf or not 2022+) SELECT InvcHead.Company AS InvcHead_Company, InvcHead.InvoiceNum AS InvcHead_InvoiceNum, s.value AS Split_SalesRep, s.ordinal AS SalesRep_Order -- mssql2022+ FROM InvcHead CROSS APPLY STRING_SPLIT(InvcHead.SalesRepList, '~', 1) s ORDER BY InvcHead.InvoiceNum, s.ordinal; InvcHead_Company InvcHead_InvoiceNum Split_SalesRep SalesRep_Order 111111 1001 RepA 1 111111 10…