Thanks RGR'us. it works fine.

Thanks very much Lee Dise, But setting

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

how does this have effect...

Thanks very much Lee Dise, But setting

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

how does this have effect on other queries.

does this stand good for the immediate query or on all further...

Hi Noel,

I want only in one grid and i want the count of records in each group because the CLIENT wants it that way.

actually this data in datagrid is then...

Hi Noel,

I want only in one grid and i want the count of records in each group because the CLIENT wants it that way.

actually this data in datagrid is then...

hi,

there is no chance for creating relations, because we will only get different groups of data. and i have to show only in one grid.

Hi govinn,

Thanks for your reply.

SELECT * INTO #Result

'Your Query with COMPUTE BY'

SELECT * FROM #Result

but i am getting an error.

Insert Error: Column name or number of supplier...

Hi Noel,

Thanks for your reply. but the prob is actually i should show this in a datagrid object in asp.net.

Also the data is very huge. I have tried rollup, but...