lonhanner (12/18/2012)
I just need the sql query to do the sort and fill the New TD_NUM.
create table TRIP_NEW
(
TD_NUM int identity not null,
other columns list
)
insert into TRIP_NEW (columns list)
select columns list from TRIP
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)