Re: [GENERAL] Convert data into horizontal from vertical form

2011-05-20 Thread Adarsh Sharma
Emanuel Calvo wrote: 2011/5/19 Adarsh Sharma : Dear all, I am not able to insert data into a table in horizontal form. The data is in below form : A show a small set of data :- c_id f_name f_value 2 k1 v1 2

Re: [GENERAL] Convert data into horizontal from vertical form

2011-05-20 Thread Emanuel Calvo
2011/5/19 Adarsh Sharma : > Dear all, > > I am not able to insert data into a table in horizontal form. > > The data is in below form : > > A show a small set of data :- > > c_id               f_name           f_value > 2                     k1                      v1 > 2                     k2    

Re: [GENERAL] Convert data into horizontal from vertical form

2011-05-20 Thread Phil Couling
Hi Adarsh You say you need this to be done dynamically. I assume that by this you're looking for a way to have 1 query produce an increasing number of columns as you increase the number of rows in your table. This really isn't possible and doesn't fit with the model SQL was designed for. The conc

[GENERAL] Convert data into horizontal from vertical form

2011-05-19 Thread Adarsh Sharma
Dear all, I am not able to insert data into a table in horizontal form. The data is in below form : A show a small set of data :- *c_id f_name f_value* 2 k1 v1 2 k2 v2 2