Database

SELECT ColA, Count(*) <br />
FROM TblA <br />
GROUP BY ColA

/* create test table and populate */<br />
<br />
create table #b1(cola varchar(20))<br />
<br />
insert into #b1<br />
select 'India'<br />
union all<br />
select 'USA'<br />
union all<br />
select 'India'<br />
union all<br />
select 'UK'<br />
<br />
<br />
/* now the actual code */<br />
<br />
<br />
DECLARE @SQL nvarchar(4000)<br />
SET @SQL=''   <br />
<br />
SELECT @SQL= @SQL +<br />
'SUM(CASE WHEN cola=''' + a.cola + ''' THEN 1 ELSE 0 END) AS [' + a.cola + '],'<br />
FROM (select distinct cola from #b1) as a<br />
<br />
select @SQL = left(@SQL,len(@SQL)-1)<br />
<br />
SET @SQL='SELECT ' + @SQL + ' FROM #b1'<br />
EXEC(@SQL)

Christian Graus wrote:

OleDB classes