Still cant get around not declaring @oldimage as image in your example.
I tried the following addition;
INSERT INTO
SketchTable
(
intMasterAcctID,
intBuildingID,
imgSketch
)
VALUES
(
@intMasterAcctID,
@intBuildingID,
(Select imgSketch from SketchTable where intMasterAcctID=@intOldMasterAcctID and intBuildingID=@intOldbuildingID )
GO
error received:
Server: Msg 1046, Level 15,...