Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
 Posted - 2001-06-01 : 02:18:30
|
| Hi Gurus..Is this possible in Single SQL Statement...I have a table Structure like :No...Field1...Field2....Field30.......0.........0......10001....100.........0.........02......0.......200.........03.....50.......100........0And I want the result like :No...Field1...Field2....Field30.......0.........0......10001....100.........0........9002......0.......200.......11003.....50.......100.......1150Actullay .. what is happening in above is.....Field3 = previous(Field3) (Minus) field1 (plus) field2I hope you got it....Queries are welcome....Thankx in Advance.... |
|
|
|
|
|
Needs... Single SQL Statement