Don

try this

create table #t(id int ,name varchar(10),region char(2),No_cut int)

insert into #t values(1,'Albert' ,      'US' ,           12)  
insert into #t values(2,'Albert'  ,     'FR' ,           91  )
insert into #t values(3,'Albert' ,      'EC' ,            2  )
insert into #t values(4,'Cecilia' ,     'US'  ,           3 )
insert into #t values(5,'Cecilia',      'CA' ,            4  )
insert into #t values(6,'Cecilia' ,     'CH' ,           34 )
insert into #t values(7,'Cecilia' ,     'FR' ,           12 )
insert into #t values(8,'Martha' ,      'EC' ,            9 )
insert into #t values(9,'Rodrigo' ,     'CO' ,            2 )

select t.[name],t.region,t.No_cut,rs.Cnt from #t t inner join

(
select count([name]) Cnt,[name] C_name from #t
group by [name]
)rs on rs.C_name=t.name

vinu
 Hello all

 Here you will find what I need

 ---------------------------------------------
 Name        Region    No_Customers   No_Names
 ---------------------------------------------
 Albert       US            12          3
 Albert       FR            91          3
 Albert       EC             2          3
 Cecilia      US             3          4
 Cecilia      CA             4          4
 Cecilia      CH            34          4
 Cecilia      FR            12          4
 Martha       EC             9          1
 Rodrigo      CO             2          1
 ---------------------------------------------

 Where Name is the sales representative
 Where Region is the country
 Where No_Customers is the number of customers in each country
 Where No_Names [must be] the number of times a Name appears in the column Name

 Te table [Data] has this structure:
 ID, Name,Region.
 The goal is to create a column with the number of times that a name is repeated in the Name column.
 e.g. Cecilia appears 4 fours because her name is in 4 regions.
 Albert apeears 3 times so it shows 3 in No_names
 I hope I was clear with my output example.

 dj.