delete from Reference#ExternalDBKeys where DB = 131147 and DBKey like "01/%"
go

insert Reference#ExternalDBKeys(Reference, DB, DBKey, Comment)
select R.ID#, 131147, '01/'+Number+substring(lower(A.Name),1, patindex('%, %',A.Name)-1)+'.html', "full text"
from Person A, Reference R, Reference#Authors RA where
R.Volume="1" and R.In1=13126  and R.ID#=RA.Reference and Order1=1 and
RA.Author=A.ID# and R.Number != NULL
go