Concat table to one field
The senario is Order with the items in a 'Detail' table.
I have a need concat the detail (Quantity and Productname +crlf) into one
field and return it with a query of the Order table.
This is so I can have the order information and the detailed line items in
a text 'memo' field.
Otherwise you end up with multiple records when joining items and order tables.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL