sql 2005
I have a table that looks like:
Date BeginValue EndValue
12/1/2008 04:00:00 0 100
12/1/2008 10:00:00 100 600
12/1/2008 18:00:00 600 400
12/2/2008 11:00:00 0 200
12/3/2008 10:00:00 300 1000
12/3/2008 19:00:00 1000 1100
what I need is the following:
Date Change
12/1/2008 400
12/2/2008 200
12/3/2008 800
Any help is appreciated.
I have a table that looks like:
Date BeginValue EndValue
12/1/2008 04:00:00 0 100
12/1/2008 10:00:00 100 600
12/1/2008 18:00:00 600 400
12/2/2008 11:00:00 0 200
12/3/2008 10:00:00 300 1000
12/3/2008 19:00:00 1000 1100
what I need is the following:
Date Change
12/1/2008 400
12/2/2008 200
12/3/2008 800
Any help is appreciated.