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 |
|
ravininave
Posting Yak Master
111 Posts |
 Posted - 2010-04-03 : 23:36:29
|
| I'm uploading some data onto my server. After uploading some figures I've to Calculate some brokarage and update some other tables. Should I use On Update Triggers or should I write code in my ASP.NET. I haven't used Trigger ever before. Suggest me the Best.VB6/ASP.NET------------------------http://www.nehasoftec.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-04 : 02:05:09
|
| is the uploading done by some job? if yes, as Tara suggested write a procedure with your logic to Calculate the brokarage and update some other tables and then make it the next step of the job.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ravininave
Posting Yak Master
111 Posts |
Posted - 2010-04-04 : 21:53:56
|
quote:
Originally posted by visakh16
is the uploading done by some job? if yes, as Tara suggested write a procedure with your logic to Calculate the brokarage and update some other tables and then make it the next step of the job.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Well, I've to calculate brokerage whenever user uploads some data. This calculations would be quite heavy when data would increase. So I'm thinking about to write some triggers. If I would write some procedures and call it from CodeBehind then I'm thinking that it would take more timeVB6/ASP.NET------------------------http://www.nehasoftec.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Should I Write Triggers