This looks great. Thank you so much. So you are basically everytime you go around checking the accumulator table for the group that has the smallest size and...

So this is what I came up with. It looks a bit clunky but it does seem to work. I am curious to see what yours looks like. ...

Sorry About that. I appreciate your help. I have been playing around with this and am getting closer. But I would definitely like to see what you...

That is the plan.

This gets me a bit closer.

SELECT NTILE(10) OVER (PARTITION BY groupmb ORDER BY database_id) AS groupid, database_id, NAME,sub.DataMB, sub.groupmb

FROM (

Select database_id, name, dbi.DataMB,

CASE WHEN dbi.DataMB <1000 THEN 1

WHEN dbi.DataMB...

Thank You. So now looking at the results more clearly, this does give me closer to what I am looking for the only thing is when you have more...

I have not ever used service broker. I'll have to do some reading on that approach. Thanks for the input.

Thank you. We are using Ola's scripts. We do not use replication. The multiple databases are per customer databases with one shared database.

The one thing that...

Ok. So you think I am headed in the right direction. Just wanted to make sure I wasn't thinking crazy.

thanks

thank you. the @ sign was the other piece I was missing.

I was able to get it to work using the cross apply method

So I am obviously not understanding something, I tried to apply the same logic to this query and I am getting null back for the OfferId. What am I...

I'm assuming the OP is me but what does it stand for? And I hadn't checked the actual data yet only the counts.

Thank you. I actually like the version not using cross apply.

Perfect. Thank you.