Pivoting Without Aggregation Feb 18, 2010 You can't remove the aggregate function, but you can take away its effect