2nd with MICHAEL DEPAULA

I did similar thing to do this work.

I know sometime business requirement is to see column data at specific place when user do select top 100 * from table (nolock) etc...

I solved this with below steps

1) Renamed the table to tablename_old.

2) Added new column in tablename_old.

3) Scripted out the table and reorginized the column.

3) Moved data matching the columns of both table.

Thanks..