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 |
Gom
Starting Member
4 Posts |
Posted - 2009-03-24 : 08:47:16
|
This is my table values Stnname Arrtime Deptime RDay trainno BANGALORE CY JN 00:00:00 17:15:00 1 2684 ERANAKULAM JN 04:20:00 00:00:00 2 2684 BANGALORE CY JN 00:00:00 17:15:00 1 6315 ERANAKULAM JN 04:50:00 04:55:00 2 6315 BANGALORE CY JN 00:00:00 18:50:00 1 6321 ERANAKULAM JN 06:30:00 06:40:00 2 6321 BANGALORE CY JN 00:00:00 06:15:00 1 02677 ERANAKULAM JN 17:45:00 00:00:00 1 02677 BANGALORE CY JN 00:00:00 17:15:00 1 0642 ERANAKULAM JN 04:30:00 00:00:00 2 0642i want the below o/p from this tablehow to copy the row values from one row to another?stnname Dest SArrtime Darrtime SDeptime DDeptime SRDay DRDay Strainno Dtrainno BANGALORECYJN ERANAKULAM JN 00:00:00 04:20:00 17:15:00 00:00:00 1 2 2684 2684 |
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-03-24 : 09:16:59
|
the train number you have in here...will that always be in pair? |
|
|
|
|
|