Now, I want to do similar calculation within SQL Server Database Table. Is it possible to write a SQL Query that will give output similar to the result shown in this excel snapshot on the right hand side ?
I have added the script that will create the Sample Database named " TestDB1001 " and Table named " Table1001 " used in this work, in the text file that is attached.
I have also attached the Excel Sheet showing the actual data as well as the required output.
How to do get such query output in SQL Server ? Any help is appreciated.