Here's what I'm trying to do.  I know how to do it with a temp table and/or
cursor, but was wondering if anyone else knows a more elegant way...

This is about taking a list of parts for an electronic assembly and
reformatting it for output on a report.

Here's an example dataset:
Partnumber    Designator
--------------------------------------
Cap1U0        C1
Cap1U0        C2
Cap1U0        C3
Cap1U0        C6
Cap2U2        C4
Cap2U2        C5

And here's now I'd like it to come out:
Partnumber    Designators
--------------------------------------------------------------------
Cap1U0        C1, C2, C3, C6
Cap2U2        C4, C5

Sort of like a pivot table, but instead of the rows coming out in separate
columns, I want all the (varchar) values in the second column concatenated
into *one* column.  Basically like "group by" with "sum()" but summing text
instead of numbers :^)

Anyone got any clever ideas on this one?

Thanks!

Eric Law
Divesified Technologies, Inc.

PS This is on SQL server 2000 SP4 if it matters.