Table Information From SQL Server

Hi

I have a problem I am trying to ascertain the quality of the data in the table of a system we are migrating from one database to another.

We have already taken the step of converting it into SQL server to make sense of it now I wnat to query the data itself

To do this I set up a query that went through sysobjects and syclumns and listed the tables and their columns

What I want to do now is use this information to query the data elements themselves to determine where we should concentrate our data mapping on.

I started out with a cursor doing this
declare @table varchar(50)
declare @col varchar(50)
declare @result int
declare count_cursor cursor scroll
for select tname,cname from infotemp
open count_cursor
fetch from count_cursor
into @table,@col
while @@fetch_status=0
BEGIN
exec ('select count('+@col+') from '+@table)
Fetch next from count_cursor into @table,@col
END
close count_cursor
deallocate count_cursor

But I am having problems getting the counted value into the result value from the exec statement

Anybody got any ideas

Thanks