Hi
Hope somebody can help. The following is just an simple example of what I need to do. I am queering the Table "SomeTable" for "Number", "Type" and "Value" values:
SELECT [Number], [Type], [Value] from [SomeTable] ORDER BY [Number]
The result looks like this:
1 A 110
2 B 220
3 A 330
4 B 440
5 A 550
6 A 660
7 B 770
8 C 880
The result I am looking for is:
1 A 110 330
2 B 220 440
3 A 330 550
4 B 440 770
5 A 550 660
I think to remember that is is possible to so something like
SELECT [Number], [Type], [Value], [Value]+1 from [SomeTable] ORDER BY [Number]
But I do not remember how to add this "+1"
Peter Schwennesen
Hope somebody can help. The following is just an simple example of what I need to do. I am queering the Table "SomeTable" for "Number", "Type" and "Value" values:
SELECT [Number], [Type], [Value] from [SomeTable] ORDER BY [Number]
The result looks like this:
1 A 110
2 B 220
3 A 330
4 B 440
5 A 550
6 A 660
7 B 770
8 C 880
The result I am looking for is:
1 A 110 330
2 B 220 440
3 A 330 550
4 B 440 770
5 A 550 660
I think to remember that is is possible to so something like
SELECT [Number], [Type], [Value], [Value]+1 from [SomeTable] ORDER BY [Number]
But I do not remember how to add this "+1"
Peter Schwennesen