Get opening and closing stock balance in SQL Server

makumbi
 
on Dec 02, 2022 11:55 PM
426 Views

How can i get closing stock balance and opening stock balance from this record using sql server

dates BookName bookcode qty category
29-May-2021 INTRODUCTION TO BIOLOGY 1 1 BIOLOGY
29-May-2021 INTRODUCTION TO BIOLOGY 2 1 BIOLOGY
29-May-2021 INTRODUCTION TO BIOLOGY 3 1 BIOLOGY
29-May-2021 INTRODUCTION TO BIOLOGY 4 1 BIOLOGY
30-May-2021 INTRODUCTION TO BIOLOGY 5 1 BIOLOGY
31-May-2021 INTRODUCTION TO BIOLOGY 6 1 BIOLOGY
1-Jun-2021 INTRODUCTION TO BIOLOGY 7 1 BIOLOGY
2-Jun-2021 MK SECONDARY BIOLOGY BK 3 8 1 BIOLOGY
3-Jun-2021 MK SECONDARY BIOLOGY BK 5 9 1 BIOLOGY
4-Jun-2021 MK SECONDARY BIOLOGY BK 5 10 1 BIOLOGY
5-Jun-2021 MK SECONDARY BIOLOGY BK 4 11 1 BIOLOGY
6-Jun-2021 MK SECONDARY BIOLOGY BK 4 12 1 BIOLOGY
7-Jun-2021 MK SECONDARY BIOLOGY BK 4 13 1 BIOLOGY
8-Jun-2021 MK SECONDARY BIOLOGY BK 4 14 1 BIOLOGY
9-Jun-2021 MK SECONDARY BIOLOGY BK 4 15 1 BIOLOGY
10-Jun-2021 MK SECONDARY BIOLOGY BK 4 16 1 BIOLOGY
29-May-2021 MK SECONDARY BIOLOGY BK 4 17 1 BIOLOGY
29-May-2021 MK SECONDARY BIOLOGY BK 4 18 1 BIOLOGY
29-May-2021 MK SECONDARY BIOLOGY BK 4 19 1 BIOLOGY
29-May-2021 MK SECONDARY BIOLOGY BK 4 20 1 BIOLOGY
29-May-2021 MK SECONDARY BIOLOGY BK 4 21 1 BIOLOGY
29-May-2021 MK SECONDARY BIOLOGY BK 4 22 1 BIOLOGY
29-May-2021 MK SECONDARY BIOLOGY BK 4 23 1 BIOLOGY
1-Jun-2021 NCDC: PHYSICS TEXTBOOK SENIOR ONE LOWER SECONDARY CURRICULUM 24 1 PHYSICS
1-Jun-2021 NCDC: PHYSICS TEXTBOOK SENIOR ONE LOWER SECONDARY CURRICULUM 27 1 PHYSICS
1-Jun-2021 NCDC: PHYSICS TEXTBOOK SENIOR ONE LOWER SECONDARY CURRICULUM 31 1 PHYSICS
1-Jun-2021 NCDC: PHYSICS TEXTBOOK SENIOR ONE LOWER SECONDARY CURRICULUM 36 1 PHYSICS
1-Jun-2021 NCDC: PHYSICS TEXTBOOK SENIOR ONE LOWER SECONDARY CURRICULUM 37 1 PHYSICS
29-Dec-2022 INTRODUCTION TO BIOLOGY 66 1 BIOLOGY
30-Dec-2022 INTRODUCTION TO BIOLOGY 88 1 BIOLOGY
31-Dec-2022 INTRODUCTION TO BIOLOGY 89 1 BIOLOGY
1-Jan-2022 INTRODUCTION TO BIOLOGY 90 1 BIOLOGY
Download FREE API for Word, Excel and PDF in ASP.Net: Download