Hi,
try this, as a alternative
if object_id('tpayment_order') is Not Null drop view tpayment_order;
GO
create view tpayment_order( ID, date_created, order_type, order_value )
as
select 1, 2011, 'C', 250
union all select 2, 2012, 'T', 260
union all select 3, 2011, 'C', 150
union all select 4, 2010, 'P', 650
union all select 5, 2012, 'C', 850
GO
select * from tpayment_order order by date_created, order_type
select date_created = isNull( cast( date_created as varchar(7) ) , case when grouping(date_created) = 0 then 'UNKNOWN' else '' end)
, order_type = isNull( cast( order_type as varchar(7) ), case when grouping(order_type) = 0 then 'UNKNOWN' else '' end )
, order_value = sum(order_value)
from tpayment_order
GROUP BY Cube(date_created, order_type);
thank's
So say we all!