Home Forums SQL Server 7,2000 T-SQL Running a stored proc on table results RE: Running a stored proc on table results

  • This actually sounds like a good idea! all I have to do now is work on creating the loop. Anybody want to provide a code sample?

    quote:


    Table data type can't be used as a parameter in stored procedures!

    you will have to create a loop to cyle through the table to either send an message per rep or better yet concatenate all reps email addresses separating them by semicolon

    and send a unique email with the recpientlist built as explained above

    HTH