Hi maz,

oops!! i made typing mistake...any ways thanx for the qry.

regards,

Ahmad

Hi chirag ,

Thanx for help.

I have used count and sum in my query to get category count and sales

Qry is somwwhat like this

select z.category,x.count(distinct customers),y.sum(sales) from

x inner join y...

Hi

Actualy I have used distinct im my query thus i can't use roll up

thanks,

is array is supported in SQL server 2000.