请教SQL 2005 从重复数据中提取开始和结束时间

我有以下表:
ID                           Created_time                                           eventcode
10254                    2008-03-09 00:15:30.159                        Start
10254                    2008-03-09 17:15:30.159                        Start
10254                    2008-03-15 07:15:30.159                        End
10254                    2008-03-15 07:15:30.159                        End
10254                    2008-04-10 17:15:30.159                        Start

判别方法: 同一个ID, 第一个Start为Real_start_1, Start后第一个End为Real_End_1, 然后第一个Start为Real_start_2, 再后第一个End为Real_End_2,重复判别. 希望结果入下:

ID                           Created_time                               eventcode      Newcode
10254                    2008-03-09 00:15:30.159           Start            Real_start_1
10254                    2008-03-09 17:15:30.159           Start
10254                    2008-03-15 07:15:30.159           End             Real_End_1
10254                    2008-03-15 07:15:30.159           End
10254                    2008-04-10 17:15:30.159           Start           Real_start_2

非常感激