ert data
>> 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
ECTED]
[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 only
'
>>
>>
>>
>> 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 man
n :)
>
> With 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 PROTECTE
g the number of
columns. Hope this makes it a clearer.
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
y
.
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
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 routi
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
8 matches
Mail list logo