Add Many Images As Varbinary(max) To Table

Hello,

I am trying to create a statement that will update many rows in a table with images, stored as varbinary(max), into a new column.

The path/file information is all stored in another table, but I can't find a way to update more than 1 at a time. Here is the statement that works for 1 row at a time:

update tblphotos set photo = (select
BulkColumn from
Openrowset( Bulk '\**servername**PropsImagesDon Giovanni 2002PropsHorses Guts 2.jpg', Single_Blob) as photo
)
where photoseq = 27


but if I try to do something like this:


CREATE TABLE #temp (

photoSeq int,

photoLoc varchar(255),

photo varbinary(max)

)

INSERT #temp

select p.photoseq, f.fldlocation + p.photophyloc as files,
(select
BulkColumn from
Openrowset( Bulk f.fldlocation + p.photophyloc, Single_Blob) as photo
)
FROM txprops t
join tblfolders f on t.fldlocation = f.fldseq
join tblphotos p on p.photopropseq = t.propseq

begin tran

update a set photo = b.photo
from tblphotos a
join #temp b on a.photoseq = b.photoseq
where a.photoseq = b.photoseq

select * from tblphotos order by photophyloc

commit tran
drop table #temp


I get an error: Incorrect syntax near 'f'.
I think this is because I can only put a path in beside BULK.

I have investigated BULK and bcp commands, but cannot find anything to satisfy this. I tried the DTS package route, but am not getting very far.

Any suggestions? Is DTS the solution for me?