declare @query varchar(8000)
declare @tablename varchar(128)
declare @col varchar(128)
declare @count1 int

declare @maxcount int

--ADD YOUR TABLENAME HERE
set @tablename ='customersummary'
set @count1=1
set @maxcount =(select count(*) from syscolumns where object_name(id)=@Tablename)
set @query = 'Select '
--print @maxcount

while @count1 <=@maxcount
begin
set @col=(select name from syscolumns where object_name(id)=@Tablename and colorder =@count1)
if @count1<@maxcount
begin
set @query= @query +' count('+@col+'),'
end
if @count1=@maxcount
begin
set @query= @query +' count('+@col+')'
end

set @count1=@count1+1
end
set @query = @query+' from '+@tablename
print @query