Archives of the TeradataForum

Message Posted: Tue, 11 Jul 2006 @ 16:38:42 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

This is a great opportunity for an Aggregate UDF. Create a UDF that concatenates into the result string for each row of the group. Return the concatenated string at the end of the group. Works for any arbitrary and changing number of rows per group and makes the SQL really simple and straightforward.

	<Prev	Next>		<<First	<Prev	Next>	Last>>