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

[Back to original message]