Dear All

Table structure is as follows

Create table tablea(

Yy numeric(13,3),

Xx varchar(100),

somedate_column datetime)

What i wanted was like cube or rollup is there a way to make single query rather than union