Copy timestamp data between columns

We have a table that was corrupted during a hardware outage and there
are no backups for the data !!
We are able to restore all the data, but there are torn pages in a
table called "WorkItem".
I wanted to copy what I could out of the workitem table and copy it to
workitem2. Noticed the timestamp column in the workitem table would
not allow me to execute:
insert into workitem2 select * from workitem where x = y
Select * into workitem2 from workitem where x= y is not good because
there are multiple runs that need to be executed to pull in workitem2
data. This statement creates the table.
FYI
To work around this - exported the data to a text file and re-
imported.
On Nov 13, 11:28 am, Justindawg <kfw...@.hotmail.com> wrote:
> We have a table that was corrupted during a hardware outage and there
> are no backups for the data !!
> We are able to restore all the data, but there are torn pages in a
> table called "WorkItem".
> I wanted to copy what I could out of the workitem table and copy it to
> workitem2. Noticed the timestamp column in the workitem table would
> not allow me to execute:
> insert into workitem2 select * from workitem where x = y
> Select * into workitem2 from workitem where x= y is not good because
> there are multiple runs that need to be executed to pull in workitem2
> data. This statement creates the table.

Copy timestamp data between columns

We have a table that was corrupted during a hardware outage and there
are no backups for the data !!
We are able to restore all the data, but there are torn pages in a
table called "WorkItem".
I wanted to copy what I could out of the workitem table and copy it to
workitem2. Noticed the timestamp column in the workitem table would
not allow me to execute:
insert into workitem2 select * from workitem where x = y
Select * into workitem2 from workitem where x= y is not good because
there are multiple runs that need to be executed to pull in workitem2
data. This statement creates the table.FYI
To work around this - exported the data to a text file and re-
imported.
On Nov 13, 11:28 am, Justindawg <kfw...@.hotmail.com> wrote:
> We have a table that was corrupted during a hardware outage and there
> are no backups for the data !!
> We are able to restore all the data, but there are torn pages in a
> table called "WorkItem".
> I wanted to copy what I could out of the workitem table and copy it to
> workitem2. Noticed the timestamp column in the workitem table would
> not allow me to execute:
> insert into workitem2 select * from workitem where x = y
> Select * into workitem2 from workitem where x= y is not good because
> there are multiple runs that need to be executed to pull in workitem2
> data. This statement creates the table.

Copy timestamp data between columns

We have a table that was corrupted during a hardware outage and there
are no backups for the data !!
We are able to restore all the data, but there are torn pages in a
table called "WorkItem".
I wanted to copy what I could out of the workitem table and copy it to
workitem2. Noticed the timestamp column in the workitem table would
not allow me to execute:
insert into workitem2 select * from workitem where x = y
Select * into workitem2 from workitem where x= y is not good because
there are multiple runs that need to be executed to pull in workitem2
data. This statement creates the table.FYI
To work around this - exported the data to a text file and re-
imported.
On Nov 13, 11:28 am, Justindawg <kfw...@.hotmail.com> wrote:
> We have a table that was corrupted during a hardware outage and there
> are no backups for the data !!
> We are able to restore all the data, but there are torn pages in a
> table called "WorkItem".
> I wanted to copy what I could out of the workitem table and copy it to
> workitem2. Noticed the timestamp column in the workitem table would
> not allow me to execute:
> insert into workitem2 select * from workitem where x = y
> Select * into workitem2 from workitem where x= y is not good because
> there are multiple runs that need to be executed to pull in workitem2
> data. This statement creates the table.