loop statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mecn - 15 Jul 2008 22:11 GMT

hi,

I have a SP created in a center DB A.
I created a table in A with one field dbname (15 db names)
DBname
db1
db2
db3
db4
.
.
.
.
.

I need to run that SP against all these tables listed in the table by loop
through.

How do I acomplish these by coding?

Thanks,

Reply to this Message

Eric Isaacs - 16 Jul 2008 00:54 GMT

What does your stored procedure do to these tables? You might be able
to have it do dynamic SQL against a passed in databasename, similar to
the following:

DECLARE @DBName as VARCHAR(100)

SELECT @DBName = MIN(DBName) FROM A

WHILE @DBName IS NOT NULL
BEGIN --loop

EXEC('SELECT * FROM ' + @DBName + '.tablename')

SELECT @DBName = MIN(DBName) FROM A WHERE DBName > @DBName

END --loop

-Eric Isaacs

Reply to this Message

Mecn - 16 Jul 2008 14:02 GMT

got it. Thanks

> What does your stored procedure do to these tables? You might be able
> to have it do dynamic SQL against a passed in databasename, similar to
[quoted text clipped - 14 lines]
>
> -Eric Isaacs

Reply to this Message