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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-12 : 08:59:21
|
anandhi writes "i have two columns like this say my orginal table time task----- -----18:44:18 4018:39:56 4018:31:48 3718:16:11 3818:15:28 3817:53:41 37i have to create a new table asstart_time stop_time----------- ----------18:39:56 18:44:1817:53:41 18:31:4818:15:28 18:16:11 so i have to read the task column, first value is 40 next search for the same value in the column,if it matches then i save their corresponding time as start and stop time. how to do this, using stored procedures, if you can help me with samples" |
|
|
|
|
|
search