Hi all!
I know this is probably way off topic and this forum might not even be the best place to ask but before I venture to unknown forums I wanted to start at home! :) I'm not sure if SQL is best to perform the task at hand or maybe a batch or Python script to run the SQL. Just looking for your thoughts and any ideas are much appreciated! Below is what I'm looking to do. Let me know if you need additional info to get me the best response! :)
We have an existing Database that is continuously being updated. What I need to do is run a Query, daily, and email the results to a particular email address. Each day I want the script to grab only the top 15 results. It would need to sorted by Due Date. We have a column for Completed but it doesn't need to show in the report but I would imagine that I need it in the query so the results can be updated each day. Out of all the columns in the DB I only need to Query about 6 and display in the results all 6 besides the Completed column.
If possible, I'd like the email to include the results in HTML format rather than an attachment. Thanks in advance for you help all! :)
I know this is probably way off topic and this forum might not even be the best place to ask but before I venture to unknown forums I wanted to start at home! :) I'm not sure if SQL is best to perform the task at hand or maybe a batch or Python script to run the SQL. Just looking for your thoughts and any ideas are much appreciated! Below is what I'm looking to do. Let me know if you need additional info to get me the best response! :)
We have an existing Database that is continuously being updated. What I need to do is run a Query, daily, and email the results to a particular email address. Each day I want the script to grab only the top 15 results. It would need to sorted by Due Date. We have a column for Completed but it doesn't need to show in the report but I would imagine that I need it in the query so the results can be updated each day. Out of all the columns in the DB I only need to Query about 6 and display in the results all 6 besides the Completed column.
If possible, I'd like the email to include the results in HTML format rather than an attachment. Thanks in advance for you help all! :)
Aucun commentaire:
Enregistrer un commentaire