Hi Ignacio,
First of all, I assume the group by query you are trying to do is something like this.
Select Type, Category, Sum(amount) total from table group by Type, Category;
Since you are saying that you would like to save it to a NEW table, you would normally in SQL Server use the select
* into table1 syntax as this will create a new table. Unfortunately that is not supported in SQL Azure because SELECT INTO statements, does not support the creation of clustered indexes which is required by SQL Azure.
To work around this you need to create your destination table then call INSERT INTO.
------------------------------------
Cotega - SQL Azure Database Monitoring, Alerts and Task Scheduling