Use SQL to obtain tableid

You need to query tableid from sqldictionary. tableid and fieldid are stored in this table.

 

Alter procedure getimageofitemid @ Itemid varchar (20)
As
Begin
Select top 1 A. Itemid,
B. act_designno,
D. image,
C. reftableid
From inventtable
Join act_designnotable B on A. act_designno = B. act_designno
Join docuref C on C. refrecid = B. recid
Join docuimgs D on D. refrecid = C. recid
Where C. reftableid in (select tableid
From sqldictionary
Where fieldid = 0 and
Name = 'act _ designnotable'
)
And a. Itemid = @ Itemid
End
Go