Re: [sqlite] Transpose table

2006-12-14 Thread Kees Nuyt
gt;> to 'new' >> >> >> >> But please be sure that you need exactly such transformation. It is a >> _denormalization_, almost anytime people try to perform conversion >> exactly as you describe but in reverse direction :) >> >> With a 'new' table many o

RE: [sqlite] Transpose table

2006-12-14 Thread Denis Povshedny
] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 14, 2006 1:41 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Transpose table Have tested this now and it seems to work fine. Faster as well than my old method. RBS > Hi Denis, > > Yes, it is a one-off action and the onl

RE: [sqlite] Transpose table

2006-12-14 Thread bartsmissaert
> >> >> But please be sure that you need exactly such transformation. It is a >> _denormalization_, almost anytime people try to perform conversion >> exactly as you describe but in reverse direction :) >> >> With a 'new' table many operation, such as adding an

RE: [sqlite] Transpose table

2006-12-14 Thread bartsmissaert
a 'new' table many operation, such as adding another one value for > ID = 1, will lead to ALTER TABLE ADD COLUMN, etc. You will come away > from SQL logic. > > Regards, Denis > > -Original Message- > From: RB Smissaert [mailto:[EMAIL PROTECTED] > Sent: Thursday, Decemb

RE: [sqlite] Transpose table

2006-12-13 Thread RB Smissaert
. RBS -Original Message- From: Darren Duncan [mailto:[EMAIL PROTECTED] Sent: 14 December 2006 06:59 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Transpose table Can you please provide a use case for your example, so we know what you're trying to accomplish? That should help us to help

Re: [sqlite] Transpose table

2006-12-13 Thread Darren Duncan
Can you please provide a use case for your example, so we know what you're trying to accomplish? That should help us to help you better. -- Darren Duncan At 12:08 AM + 12/14/06, RB Smissaert wrote: I am moving my code away from VBA and transferring it to SQL. There is one particular

[sqlite] Transpose table

2006-12-13 Thread RB Smissaert
I am moving my code away from VBA and transferring it to SQL. There is one particular routine where I haven't found a good replacement for and that is to transpose a table from a vertical layout to a horizontal one, like this example: ID Value - 1 A 1 B 1 A 3