I have a similar problem. Were you able to solve the problem?

thanks

it worked

thank u

sam

This should work:

Select  

 Max(Case Color When 'Red' Then 'Red' End) as Color1,

 Max(Case Color When 'Green' Then 'Green' End) as Color2,

 Max(Case Color When 'Blue' Then 'Blue' End) as Color3

From  #Temp

sam

here's microsoft's solution:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_7pv0.asp

hope it helps...........