Posted by Stu on 12/05/05 21:36

There's not a set-based method; the BEST method is to use the client
application to accomplish this. Visual Basic, C#, Java, etc, are all
desigined for munging arrays in this fashion.

If you must do this on the SQL side (for email reports, etc), then you
can use a cursor. But cursor performance will suck.

Stu

• Next in forum: Re: Compile/combine the contents of several records.
• Prev in forum: Compile/combine the contents of several records.
• Thread view: Re: Compile/combine the contents of several records.

[Reply to this message]