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 |
|
purple cloud
Starting Member
2 Posts |
 Posted - 2007-06-11 : 05:04:38
|
hi there, i m newbie in using the ms sql server.i wouldlike to learn how to write the store procudure.i hope u all can guide me on this.i have one table with dataappid int (PK)leaveappid int (FK)firstapproval intfirstapproval email varchar,2nd approval int2nd approval email varcharresutl firstapprovalresult secondapproval.i would like to do a automatic send mail function where: the first mail will send to the firstapproval email.if after 2 days, the firstapproval no response(the result firstapproval is empty) then the email will automatic send to the second approval. how can i write the SP for this case? i really have no idea to start since i duno how to write the SP syntax and dont have the concept too.hope can hear from u all soon.thanx |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-11 : 05:45:10
|
| this isn't something that you should be handling in a stored procedure if you ask me...you do have database mail that can send emails with no problems.other mail stuff should be handled outside of the db._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
Store procedure -auto send email