declare @Column1 int
declare @name varchar(60)
declare @column2 int
Declare @Count int
Declare @SQL VarChar(3000)
Declare @NumberRecords int
Declare @RowCount int

create table #dbs	(
     RowID int Identity(1,1),
	 dbname varchar(60),
)

create table #Results  (
	[DBName] varchar(60), 
	[Count1] int,
	[Count2] int,
	[Count3] int,
	[Count4] int,
	[Count5] int,
	[Count6] int,
	[Count7] int,
	[Count8] int,
	[Count9] int,
	[Count10] int,
	[Count11] int,
	[Count12] int,
)

INSERT INTO #dbs
SELECT db
 from dblist
SET @NumberRecords = @@ROWCOUNT

SET @RowCount = 1
WHILE @RowCount <= @NumberRecords
BEGIN

SELECT @Name = db from #dbs where rowID = @RowCount

		Select @SQL = 'Select CAST(''' + @Name + ''' AS VARCHAR(60)) AS ''Db Name'', count(recordsource) as count1,
					 SUM(case when field IN (''9'', ''Q'') then 1 else 0 end) as count2 ,
					 SUM(case when field IN (''B'', ''P'') then 1 else 0 end) as count3 ,
					 SUM(case when field =''1'' then 1 else 0 end) AS count4,
					 SUM(case when field =''2'' then 1 else 0 end) AS count5,
					 SUM(case when field =''4'' then 1 else 0 end) AS count6,
					 SUM(case when field IN (''6'') then 1 else 0 end) AS count7,
					 SUM(case when field IN (''7'', ''S'') then 1 else 0 end) AS count8,
					 SUM(case when field Not In (''Q'',''B'', ''9'',''1'',''2'', ''4'', ''6'', ''P'', ''7'', ''S'') then 1 else 0 end) AS count9,
					 (Select Count(distinct field2 ) from ' + @name + ' where field2 <> '''') As count10,
					 (Select Count(distinct field3 ) from ' + @name + ' where source2=1) As count11',
					 SUM(case when field4=1 then 1 else 0 end) as count12
					 	 from ' + @name 
		
		Insert #Results
		Exec(@SQL)

		Set @RowCount = @RowCount + 1

      end

go
--select * from #dbs

select * from #Results
drop table #results
drop table #dbs