Hi Gary I would say write an UDF
Thanks and Regards Rajesh On Sun, Sep 29, 2013 at 5:16 AM, Gary Zhao <garyz...@gmail.com> wrote: > Hello > > Do you know if my scenario is supported or not, or how I may do it. > Basically, I have an array in a recode, like > > [1, 2, 3] > > What I want is to explode it twice so I can have the following output: > > 1 2 > 1 3 > 2 1 > 2 3 > 3 1 > 3 2 > > I tried a few queries but couldn't make it succeed. > > Thanks > Gary > >
