SQLServer 2008 code 1

[landview]

I have a table like:
MonthOpened #ofDefectOpened MonthClosed #ofDefectClosed Oustanding
Jan 2013 50 Jan 2013 30
Feb 2013 20 Feb 2013 30
Mar 2013 60 Feb 2013 20

I need to calculate the outstanding and create the view.
Calculation for outstanding: For Jan 2013 Outstanding=#ofDefectOpened - #ofDefectClosed=50-30=20
For Feb 2013 Outstanding=Jan 2013 Outstanding+Feb 2013 #ofDefectOpened- Mar 2013#ofDefectClosed =20+20-30=10
For Mar 2013 Outstanding=Feb 2013 Outstanding+Mar 2013 #ofDefectOpened- Mar 2013#ofDefectClosed =10+60-20=50

Please let me know how to do this in Sql Sever 2008.
Thank you

 

[fredericofonseca]

and what have you tried so far? This is a fairly simple sql

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[landview]

select monthopened,#ofdefectopened,monthclosed,#ofdefectclosed,,(#ofdefectopened-#ofdefectclosed) as outstanding from the table;

but, I am unable to keep on adding the Previous month outstanding to the next month. Couldn't figure out. If you know please let me know.
Thank you.

 

[fredericofonseca]

Instead of giving you a direct solution I am pointing you out to what you need to search for.

What you have a a running total - so search both here on tek-tips and on google for "sql server 2008 running total" and you will find lots of examples with different ways of doing it.

As you will get different ways of doing it it will be a learning step for you

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886