very interesting. The point is the order of fields in the GROUP BY ROLLUP, that establishes the hierarchy.
In order to get the same result you get with CUBE using...

can you show an example of querying attributes please?

thanks in advance

what about querying attributes?

sorry, it is better to put SET NOCOUNT ON, isn't it?

sorry I read on msdn that 'Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in the next release of SQL Server'. So this method will not work...