master.dbo.sysdatabases 1

[mgp66]

How would I iterate through the master.dbo.sysdatabases names
column using the name in another db query to that (name) particular database.

OR how can I use the database name to query the database tables

 

[rac2]

DECLARE @db_name VARCHAR(50)

DECLARE daterbass CURSOR FOR
	SELECT [name] AS "dbname" FROM master..sysdatabases
	ORDER BY "dbname"

OPEN daterbass

FETCH NEXT FROM daterbass
INTO @db_name

SET NOCOUNT ON
WHILE @@FETCH_STATUS = 0

BEGIN
  SET @strQuery = 'SELECT colA, colB '
  SET @strQuery = @strQuery + ' FROM ' + @db_name
  SET @strQuery = @strQuery + + ' ..MyTable '
  SET @strQuery = @strQuery + ' WHERE conditions'

  EXECUTE(@strQuery)

  FETCH NEXT FROM daterbass
     INTO @db_name
END

CLOSE daterbass
DEALLOCATE daterbass
SET NOCOUNT OFF

 

[mgp66]

DECLARE @strQuery VARCHAR(200)

was the only thing missing.
You rock!!

ThankYou very much!