|
Posted by Marcin A. Guzowski on 06/30/07 13:39
imani_technology_spam@yahoo.com wrote:
> I wish I could, but this is a data migration. I HAVE to put this
> stuff in the table. The customer requires it. More specifically,
> Commerce Server requires it.
You have three options:
1) aggregate concatenation in cursor
2) aggregate concatenation in SELECT query
3) aggregate concatenation using FOR XML
Option 1) is the safest method.
For option 2) details refer to:
http://groups.google.pl/group/microsoft.public.sqlserver.programming/tree/browse_frm/thread/5ecab9fecb969f34/
Third method:
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/07/06/871.aspx
--
Best regards,
Marcin Guzowski
http://guzowski.info
Navigation:
[Reply to this message]
|