SQLTeam.com | Weblogs | Forums

Can u plz help me Query


I want SQL update statement to(Ex. update table... where seqno=..)

1.Update the transaction colum in the table that has previous transaction(TansactionSequence minus one) from Y to E.
2.Update the colum to Comment2
3. Update previous commnet to Comment1

Ex:Update Transaction colum 5 and 10 to E and comment colum for colum4/5 and 9/10 to comment1/comment2.
Note: 1. TansactionSequence with 1 is always Y, and can have multiple Transaction Sequence numbers.
2. SequenceNo is a primary Key

please provide your data using proper DDL and DML