Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 4th, 2004, 04:22 AM
Friend of Wrox
 
Join Date: Oct 2003
Posts: 336
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to alyeng2000
Default Which is Best For Balance tables

Hi all,
i need an advice for my case, about which is best as a solution....
to deal with balance tables (tables which have for ex. the stocks amounts)
The Question Is?
modifing this table is best to modify by trigers on update ,on insert or doing that by code ???




Ahmed Ali
Software Developer
__________________
Ahmed Ali
Senior Software Developer
 
Old March 9th, 2004, 09:28 AM
Authorized User
 
Join Date: Jun 2003
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
Default

best is not to store the stocks, but to calculate them where you need them.

defiant





Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 11 Pg 334 Running Balance JackalBW BOOK: Access 2003 VBA Programmer's Reference 0 November 29th, 2007 04:07 AM
Compute Balance zone Excel VBA 2 August 17th, 2007 09:16 AM
creating tables within tables in access??? carswelljr Access 3 August 23rd, 2006 01:21 PM
Displaying the previous days balance in report ayamas Crystal Reports 1 June 5th, 2006 06:44 AM
DB CR Balance in Form mateenmohd Access 4 October 12th, 2004 11:32 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.