There are quite few ways to do so one is using cross tab queries other is using CLR based agreegate functions

kindly read MSDN Article for CLR based agreegate functions