[wdvltalk] Re: SQL POINTERS
Rudy, I know that the prepacked sp_send_cdosysmail will do the job of sending email. that part is fine and I can send mail till the cows come home What is giving me fits is getting the horse outta of the gate. I initially did this as an ASP page. But my boss wanted to raise the challenge bar a bit and he told me to do it as a stored proc. I did it, but it was messy. I hard coded some of the variables and performed several queries to get the outcome. Done, but dirty. So now it is time to clean it up by using temp tables and subqueries to get the same output. Any pointers out there? Erich D. Mansell The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
[wdvltalk] Re: SQL POINTERS
> Can this be performed in MSSQL2k yes, everything up to the "send email" part you need a script (ASP?) or scheduled task to call the database, exec the stored proc, handle the query results, decide who gets email, and then hand the email over to some other windows network task, or server, CDONTS or something (that last part i don't know much about, as i don't do network interfaces) but the database part of your setup is quite feasible with sql2000 rudy The WDVL Discussion List from WDVL.COM To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub http://www.wdvl.com ___ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
