is it possible to execute into a table.
i.e store the output of the code below into a table

DECLARE tables_cursor CURSOR FOR
SELECT distinct tbname FROM maxsyscolumns
OPEN tables_cursor
DECLARE @tablename varchar(30)
FETCH NEXT FROM tables_cursor INTO @tablename
WHILE (@@fetch_status <> -1)
BEGIN
declare @tname varchar(128) set @tname = @tablename
EXEC ('Select '''+ @tname +''', count(*) from '+@tablename)
FETCH NEXT FROM tables_cursor INTO @tablename
END
DEALLOCATE tables_cursor

many thanks

Change the EXEC's statement to use an INSERT of the SELECT

INSERT MyTable
SEKECT COUNT(*) FROM Table

How does this relate to DTS?


--
Darren Green
http://www.sqldts.com


"fumi.omotayo (AT) ecovertfm (DOT) com" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:087d01c3da9b$6e1f7fd0$a601280a (AT) phx (DOT) gbl...

see
http://www.nigelrivett.net/sp_executeSQL.html

and

http://www.nigelrivett.net/sp_GetRowsForAllTables.html

(the second doesexactly what you want to do).

Also consider
insert tbl select o.name, i.rows from sysindexes i,
sysobjects o where i.id = o.id and i.indid in (0,1) and
o.name in (select tbname from maxsyscolumns)

You will need to update the values first to make sure of
the count in the table if you want it to be accurate.