I have a table namely tempDB. The table have col namely [PriceOfToy],[dateOfPurchase]. User will key in the price of toy and date of purchase.
How do I retrieve the all datas from tempDB and check if there is a same dateOfPurchase. If there is a same dateOfPurchase, then the PriceOfToy will be added together. The new value of PriceOfToy will then be updated in the previous row instead of creating a new row.
How do I retrieve the all datas from tempDB and check if there is a same dateOfPurchase. If there is a same dateOfPurchase, then the PriceOfToy will be added together. The new value of PriceOfToy will then be updated in the previous row instead of creating a new row.