It works fine for me. If you just do

select *, DENSE_RANK() over (partition by MailCounty order by Precinct) as Rn 
from tblCamp_CT

Do you see the same number for BERNE B ? If not, it means there are some invisible characters in that field that make the entries non-unique.



>Here's what I have. The only change was a field name typo I corrected:
>
>

>
>declare @Cols nvarchar(max), @SQL nvarchar(max)
>
>select @Cols = STUFF((select distinct ', ' + quotename(MailCounty) from tblCamp_CT order by ', ' + quotename(MailCounty) 
>for XML path('')),1,2,'')
>
>set @SQL = 'select ' + @Cols + ' from (select *, DENSE_RANK() over (partition by MailCounty order by Precinct) as Rn 
>from tblCamp_CT) X PIVOT (max(Precinct) FOR MailCounty IN (' + @Cols + ')) pvt'
>
>print @SQL -- to debug
>
>execute (@SQL)
>
>

>
>
>
>
>
>
>
>>Are you sure you're using DENSE_RANK() function? That's what my current script is using and it should work fine.
>>
>>>Naomi,
>>>
>>>This worked great. I have never done a pivot before so I learned something.
>>>
>>>One thing though.. The results in each column need to be distinct. For example, the result column Adams has:
>>>
>>>

>>>Adams
>>>---------------------------
>>>DECATUR 5                                         
>>>NULL
>>>NULL
>>>NULL
>>>SO MONROE                                         
>>>BERNE B                                           
>>>BERNE B                                           
>>>BERNE A                                           
>>>BERNE B                                           
>>>BERNE B                                           
>>>SO MONROE                                         
>>>SO MONROE                                         
>>>BERNE C                                           
>>>

>>>
>>>where it should have
>>>
>>>

>>>Adams
>>>---------------------------
>>>BERNE A                                           
>>>BERNE B                                           
>>>DECATUR 5                                         
>>>SO MONROE                                         
>>>

>>>
>>>How can I do this?
>>>
>>>
>>>>>I have never done a cross tab query (or pivot?), so I could use some help,. using SQL 208.
>>>>>
>>>>>I have a table called tblCamt_CT with columns "MailCounty" and "Precinct".
>>>>>
>>>>>

>>>>>
>>>>>MailCounty	Precinct
>>>>>----------------------------
>>>>>Hancock		WAR 035
>>>>>Hancock		WAR 030
>>>>>Hamilton		SPRING FARMS
>>>>>Johnson		WHITE RIVER 07
>>>>>Cass		Logansport 02
>>>>>Hamilton		NOBLESVILLE 09
>>>>>Hamilton		BRENTWOOD
>>>>>Hamilton		LAW 007
>>>>>Hancock		Brandywine 1
>>>>>Adams		WEST ROOT
>>>>>Adams		WEST ROOT                                    
>>>>>

>>>>>
>>>>>I want to create a result set with one column per county and a distinct list of precincts under each county, So I should end up with somethign like:
>>>>>
>>>>>

>>>>>
>>>>>Adams		Cass		Hancock		Hamilton		Johnson
>>>>>==================================================================================
>>>>>WEST ROOT	Logansport 02	Brandywine 1	BRENTWOOD	WHITE RIVER 07
>>>>>						WAR 030		SPRING FARMS				
>>>>>						WAR 035		NOBLESVILLE 09
>>>>>						LAW 007
>>>>>
>>>>>

>>>>>
>>>>>I'v never done a cross tab before. Could use some help.
>>>>>
>>>>>Thanks
>>>>
>>>>It's a bit tricky, but here it goes with dynamic pivot.
>>>>
>>>>

>>>>use tempdb
>>>>create table #Counties (MailCounty varchar(30), Precinct varchar(30))
>>>>
>>>>insert into #Counties 
>>>>values
>>>>('Hancock',		'WAR 035'),
>>>>('Hancock',		'WAR 030'),
>>>>('Hamilton',	'SPRING FARMS'),
>>>>('Johnson',		'WHITE RIVER 07'),
>>>>('Cass',		'Logansport 02'),
>>>>('Hamilton',	'NOBLESVILLE 09'),
>>>>('Hamilton',	'BRENTWOOD'),
>>>>('Hamilton',	'LAW 007'),
>>>>('Hancock',		'Brandywine 1'),
>>>>('Adams',		'WEST ROOT'),
>>>>('Adams',		'WEST ROOT')  
>>>>
>>>>declare @Cols nvarchar(max), @SQL nvarchar(max)
>>>>
>>>>select @Cols = STUFF((select distinct ', ' + quotename(MailCounty) from #Counties order by ', ' + quotename(MailCounty) 
>>>>for XML path('')),1,2,'')
>>>>
>>>>set @SQL = 'select ' + @Cols + ' from (select *, DENSE_RANK() over (partition by MailCounty order by Precinct) as Rn 
>>>>from #Counties) X PIVOT (max(Precinct) FOR MailCounty IN (' + @Cols + ')) pvt'
>>>>
>>>>print @SQL -- to debug
>>>>
>>>>execute (@SQL)