Can you check whether the stored proc is encrypted or you have proper access permissions on that proc?

I am not sure but as long as you have valid licenses, its not a compliance issue to install different editions of SQL Server on multiple VMs hosted on same...

@anand-2,

The OP already got the ID's in order, his requirement is to get the names in order based on highest ID which is the tricky part.

Together We've already...

Thanks Gail for the case syntax summary.

But in this question's context, its out of scope right?

Excellent technique to learn from you.

Can you share prototype for this report layout?

I guess its possible using custom vb coding or something similar.

Hi,

Why are you maintaining separate db table for each region / country?

Thanks Chris, now I have realized that I've missed the initial requirement to sort names by ID desc.

It's a good problem to takle.

Hi Chris,

What's the problem with my query? you've just replaced COUNT() with MAX() right?

I could test my version of the query successfully.

Can you re post your test data?

Hi,

Did you refer to my queries?

The following code from my solution would yield the required result.

with ctenames

as

(

select id, name

, row_number() over(partition by name order by id desc) as rownum

,count(name)...

Hope this helps you.

create table #name(id int, name char(1));

insert #name(ID, Name)

select 1000, 'A'

union all

select 990, 'C'

union all

select 980, 'A'

union all

select 970, 'A'

union all

select 960, 'B'

union all

select 950, 'C'

union all

select 930,...

Can you post the desired sample output.

Can you explain the significance of MAXDOP setting.