Re: Return Single Row with Multiple Cols Instead of Multiple Row

Thank you for responses, the way i need output is single line ABC Motorcycle On Road Casual ZX124 Red CA-Emision

It is tough as the model returns those as multiple rows, cause this is just the small section of SQL, actual output is giantic, it;s like Total Orders, Forecasts etc by each of above column values.

The model i am changing to is following now:

ID Level_1 Level_2 Level_3 Level_4 ... Level 10 Name 10 1

            Motorcycle
11  1             1
           On Road
12  1              1                  1
          Casual
13  1               1                  1           1
         ZX124

Let me know,

Thanks,
Anil G Received on Wed Oct 26 2005 - 18:10:12 CDT