T-SQL如何将多行合并为一行

I've googled pretty much everything I can think of and haven't been able to find a solution that fits my needs. It's pretty simple in theory: I need to combine multiple rows of a result set by their member code. The values for the price columns will always be identical per member code and there will only be one price% value per member code.I've googled pretty much everything I can think