I have the following result set stored in a dummytable.
sym id details ABC 0x00123 AAAAAAAAAA ABC 0x00123 BBBBBBBBBB EFG 0x00345 CCCCCCCCCC HIJ 0x00678 CCCCCCCCCC XYZ 0x00900 XXXXXXXXXX XYZ 0x00900 YYYYYYYYYY XYZ 0x00900 ZZZZZZZZZ
I would like to get break the details table into three columns based on symbol and details, as shown below. I have been trying to work with pivot without success. Any help would be much appreciated!
sym id details1 details2 details3 ABC 0x00123 AAAAAAAAAA BBBBBBBBBB null EFG 0x00345 CCCCCCCCCC null null HIJ 0x00678 CCCCCCCCCC null null XYZ 0x00900 XXXXXXXXXX YYYYYYYYYY ZZZZZZZZZZ