Login    Register      

Medical shop code-- sql server 2000 purchase and sales using sum Posted Date: 07 Jul 2012      Posted By:: ashok     Member Level: Bronze    Member Rank: 0     Points: 2   Responses: 1
in sql server 2000 , purchase and sales using sum whereby purchase decreases when say, Example:-purchase =50 and sales =25 and purchase gets decreased by=50-25=25 when sales from purchase is made,purchase decreases as in the above example. Tweet
Responses
#679589    Author: Nathaniel Nellas Sumaya      Member Level: Silver      Member Rank: 1262     Date: 09/Jul/2012   Rating:     Points: 2 DECLARE @purchase decimal(10,8) SET @purchase = 25 SELECT purchase-@purchase FROM purchaseTable -- Update your purchase table UPDATE purchaseTable SET purchase =purchase-@purchase
Post Reply
This thread is locked for new responses. Please post your comments and questions as a separate thread. If required, refer to the URL of this page in your new post.
Tweet

Next : Sql server 2005 query Previous : Use of row lock & table when to choose one of them Return to Discussion Forum Post New Message Category:

Related Messages Exporting SQL Server Table to Excel Using DTS Function is not working trigger problem. DATE SEARCH IN ASPX PAGE Any body tell good pl sql book reference URL and FAQ