Sum then delete one row , Sql Server

Sum then delete one row

Language: Layout:

View schema
Execution time: 0,05 sec, rows selected: 4, rows affected: 8, absolute service time: 0,19 sec

edit mode | history | discussion

  
$action
Item
Qty
FixItem
t
n

1
UPDATE
ItemRandom-1
2,00
ItemA
7,00
1

2
DELETE
ItemRandom-2
5,00
ItemA
7,00
2

3
UPDATE
ItemRandom-3
5,00
ItemB
5,00
1


  
Item
Qty
FixItem

1
ItemRandom-1
7,00
ItemA

2
ItemRandom-3
5,00
ItemB

3
ItemRandom-4
5,00


4
ItemRandom-5
5,00

λ

                                      .NET NoSQL database for rapid development