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       G
3       D
5       A

This should become:

ID      Value1  Value2  Value3
------------------------------------
1       A               B               A
3       G               D
5       A

I can't see any way to do this fast and my VB method running on arrays was
very fast.
Does anybody have any suggestions how to handle this?
Thanks for any advice.


RBS



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to