Thulasiram pakala

Thulasiram pakala

  • 1.5k
  • 509
  • 59.4k

i want in sql one query

Jan 22 2021 5:01 AM
Hi
        in two view i caluculate batch qty and one view issueqty when i select drug and from date two date i want to display the in between dates date batchqty,issueqty ,balanceqty  next row i sales some qty
 so balance today i enter 100 stock today issued 10 so balance 90 next day i sale one more 20 drugs prevoius balance batchqty 90  issue qty20 balance 70 lime that what problem is suppose i select tommarrow   enddate  batch qty today i enter so tomarrow batch qty comes zero so balance comes negitive what i want i want to check when i select form date and to date also need to check top 1  batch qtyis>0 that onw wards records need to display
any body can help for th

Answers (2)