Query to retrieve parent-child aggregate records

Try a cursor that loops through the ingredients, and concatenate the attributes to a varchar(max) string.

---

Bodo Michael Danitz - MCT, MCITP - free consultant - performance specialist - www.sql-server.de