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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Whats the best way to create a billing platform

Author  Topic 

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-03-18 : 14:32:02
hi,
Whats the best way to create a billing platform.

I have a table that creates a history of every transaction made via inserts with a stored proceedure.

now i am wondering if its better to use

1. The same SP to do my billing with the history table and other related financial tables.

2. Use a trigger or use both ?

Please advice

afrika

SqlStar
Posting Yak Master

121 Posts

Posted - 2005-03-22 : 04:01:02
Use trigger for History details and write billing related logics in SP.

:) While we stop to think, we often miss our opportunity :)
Go to Top of Page
   

- Advertisement -