CREATE TABLE #temp (imagefld image)
INSERT #temp
EXEC SOURCE_SRVR.master..sp_execsql 'SELECT imagefld FROM tbl WHERE ID =1'

UPDATE t
SET t.imagefld = t1.imagefld
FROM tbl t, #temp t1
WHERE t.ID = 1

This page was last updated on May 01, 2006 04:28 PM.