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 |
|
karthik2211
Starting Member
2 Posts |
 Posted - 2014-09-22 : 06:39:52
|
| i have a amount lets say 1000 if i pay 400 i need get a alarm stating that there is a pending amount.so like this many members will there how will you do this in sql and vs.kindly help in thiscan u please provide me the a stored procedurekarthik |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2014-09-22 : 07:51:45
|
| This is not ideal scenario to be handled from SQL Server. It can be better handled from front-end application.If you need to do this from SQL Server only, I believe you can write a trigger to check for pending amount and use COM extended stored procs to display message box.Harsh Athalyehttp://www.letsgeek.net/ |
 |
|
|
|
|
|
i have a amount lets say 1000 if i pay 400 i need