Transpose table?

[Silverstone]

Does anyone have any code which i can use to transpose columns in SQL.

E.G
id value
1 100
1 200
2 300

becomes
id value1 value2
1 100 200
2 300

I can do it in SAS but we need to be able to do it in SQL too.

thank

 

[Silverstone]

ok, forget it. I found the faq now!!