Hello All,
Is there anyway to group the bellow by SKU and BIN Number then list all the serial numbers in the column per sku and bin level and list them like AA245~AA345~AA560
look at STRING_AGG
Hello,
Thank you for this how do i run it at BAQ level or do i need to do this on the SQL server epicor database ?
It can be done in a BAQ
If you look at the whole thread, you need SQL 2017+ otherwise people used the XML FOR PATH.
I see in the example that the whole STRING_AGG statement was surrounded by parentheses.
1 Like
Yes, this is important.