Posted by Erland Sommarskog on 06/27/07 07:29

M@ (mattcushing@gmail.com) writes:
> found a really good alternative on sqlteam.com
>
> USE Northwind
> GO
> CREATE FUNCTION dbo.ConcatOrderProducts(@OrderID int)
> RETURNS VARCHAR(8000)
> AS
> BEGIN
> DECLARE @Output VARCHAR(8000)
> SELECT @Output = COALESCE(@Output+', ', '') + CONVERT(varchar(20),
> P.ProductName)

Beware! The correct result of this operation is not defined! You may get
what you want, you may get something else! It works most of the time,
but there is no guarantee!




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Strange performance issue with UPDATE FROM
• Prev in forum: Re: How to find the maximum possible value of a given datatype
• Thread view: Re: Concat tables into one row in view

[Reply to this message]