Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-02 : 07:17:46
|
| Pedro writes "I have a table in SQL 2000, each record has a few fields such as "email address", "date" and others. I need to somehow Create a query for each record containing that records data.example: SELECT "datefield" FROM table WHERE "Otherfield" = somthing. then email the results if any to that records "emailaddress"this will have to run for every record in that table, send email if there are any results at a set time of the day.is this possible? Thanks for your help" |
|
|
|
|
|
Create query, run, then email results