Posted by Anith Sen on 11/07/06 14:54

For a one time data display or if this is used by a single application or a
report, you should consider retrieving the resultset to the client side,
leverage the display/presentation language's string manipulative features
and appropriately format the data there.

If this is more of a general requirement and used by several applications,
in certain cases it may make some sense to do it at the server using t-SQL.
For some options see: http://www.projectdmx.com/tsql/rowconcatenate.aspx

--
Anith

• Next in forum: Changing column values on table insert trigger
• Prev in forum: t-sql turn off a cpu
• Thread view: Re: Return dataset in one column

[Reply to this message]