Hi, I require help in finding a duplicate order based on detail lines please.
e.g. John ordered ProductA + ProductB + ProductC + ProductD on one order.
I need to inform him if he attempts to order the combination of ProductA + ProductB + ProductC + ProductD again.
Attached is a horrible attempt. It is incorrect. I dont know of better.
I tried to summarize each order into one line
but it is terrible - im using a cursor and in the real app there are thousands of records so i wont be able to use it. Please assist