sql server new users: Luke, use the force :-) :

CREATE TABLE Sometable3
(
ID INT,
FileData IMAGE
)

GO

CREATE TABLE Sometable4
(
ID INT,
FileData IMAGE
)

INSERT INTO Sometable4
(
ID,
FileData
)
SELECT ID,FileData
FROM Sometable3

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Hi,
I like to transfer image records from a table into another table with
similar structure in a procedure.

Table1:
date, photo_id, photo, tx_flag
Table 2:
date, photo_id, photo

How to write a procedure call to transfer table1's records to table2?

Thanks,

Luke