Is this only for a report? Cause you don't need to change the data in the base table (not sure you're not doing that

Loops AJ?? Is that how you want to cross the big K????

Declare @Sample as int

Declare @OffSet as int

SET @Sample = 3

SET @OffSet = 1

SELECT

O1.id, O1.Name, count(*) as Rank

FROM...

I wanted to go to 1M loops but some employees got here sooner than expected so the test had to stop at 100K :

Loops : 1       RPC : 16       ...

ya that makes more sens . No you know I never had multi processor server .

Tx.

Yup sample data and expected results are definitly required here.

Ok in french or in other english words .

Translation in english please?

Select * from dbo.SysObjects maxdop1 this should stop that error from occuring.

Just for clarity. Can you post some sample data for each table and the results you wish to get from the query. It's still a little hard to...

I'll try to get at work an hour earlier... that way I'll have the whole system to myself so that network and server load won't be an issue.

Thanx for the warning.

Please finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=21&messageid=200266

I never worked with the analysis services... I'm gonna have to pass this on to other DBAs.

If you need help with the code, post the table and view definition (with keys) and some sample data so we can cook it up for you.

Did you try my version of the query???