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
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
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
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