Re: Multiple values into single cell

#1

NAJH (neilonusenet (AT) yahoo (DOT) co.uk) writes:

Quote:

For reasons best ignored, I want to produce a query which has columns:

Orders.OrderID, Products

which has results like:

10248, 'Queso Cabrales, Singaporean Hokkien Fried Mee, Mozzarella di
Giovanni'
10249, 'Tofu, Manjimup Dried Apples'

________
so for those who don't really know what I'm on about and haven't got
access to northwind, I want the second cell to contain the returned
column of a second query (but in text format)

could anyone suggest a way this could be done? am I entering the land
of cursors?

If you are on SQL 2000, yes. SQL Server MVP Anith Sen covers the various
methods on http://www.projectdmx.com/tsql/rowconcatenate.aspx.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#2

Quote:

For reasons best ignored, ...

Do not ignore the reasons; so, why do you want to write stinking bad
code?

#3

--CELKO-- wrote:

Quote:

For reasons best ignored, ...

Do not ignore the reasons; so, why do you want to write stinking bad
code?

At least he isn't talking about storing the data that way, merely
outputting it that way. That said, I would do it in a separate
reporting layer (e.g. Crystal Reports) if at all possible.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Multiple values into single cell

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: Multiple values into single cell - 05-18-2007 , 03:47 PM

Re: Multiple values into single cell - 05-20-2007 , 04:41 PM

Re: Multiple values into single cell - 05-20-2007 , 09:27 PM