how to calculate sum(discount) when check box status ='Y'
991535Mar 9 2013 — edited Mar 25 2013Hai.
This is Venkatesh i want sum(disc) of particular items when check box STATUS='Y'
I Selected data from quota_det TABLE
i have 5 items codes
SNO ITEM ITEMCODE QTY PRICE BASIC DIS_PER DISC STATUS
1. DELL D26OO 2 30000 60000 5 57000 Y
2. HP HP2300 1 20000 20000 2 19600 N
3. SAMSUNG SM560 2 5300 10600 3 10282 N
4. NOKIA NK63 5 25600 128000 3 125440 Y
5. HTC HT25 1 2300 2300 2 2254 Y
ALL ARE DATABASE ITEMS BUT STATUS IS NOT A DATABASE ITEM THAT IS CHECK BOX ITEM
VALUE WHEN CHECK= Y
VALUE WHEN UNCHECK= N
IN ABOVE DATA I WANT ONLY SELECTED ITEMS SUM(DISC) WHEN CHECK BOX ITEM CHECK THAT SUM MUST BE APPEAR IN TOT_VALUE* ITEM*
PLEASE SEND CODE FOR ABOVE REQUIREMENT WITH TRIGGER NAMES ITS URGENT...
Edited by: 988532 on Mar 22, 2013 10:27 PM