Hey,

Try this code.

Create table #name

(

Name varchar(5),

Value int null

)

go

insert into #name (Name)

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'XYZ'

union all

select 'XYZ'

union all

select 'XYZ'

union all

select 'XYZ'

union all

select 'MNO'

union all

select 'PQR'

union all

select 'PQR'

go

select Name,count(Name) as Cnt

into #Cnt

from #name

group by Name

Select Name,N*10

from #Cnt,Tally

where N <= Cnt