Need help. Newbie

[nick122211]

Ok this is what I am trying to do. I need to select all rows from one table and feed them into a execute statement and have that statement run for each row of the other table.

Not sure where to start?


declare @ServerName VarChar(100)
begin
select @serverName = (Select server from SMTPAlert.dbo.servers)

exec SMTPAlert..sp_send_cdosysmail @serverName

end

Any help would be much appreciated

 

[r937]

i'm going to guess that you should be posting this question in the microsoft sql server forum, forum183

this forum is for ANSI SQL

r937.com | rudy.ca