Try using this simple crosstab SP :

Usage: Exec crosstab <Entire Select statement as you would write to get a group by on rate>, <the field to sum (rate in this...