I have a test environment SQL Server 2008 R2 Express Edition. I have attached a snapshot of the table below. Here i have some columns which are having salary details. I have a seperate column where there is a total salary column.
I want the green band added and red band subtracted and the blue band to be the total.
I am a newbie to sql.. please help