INSERT INTO DBO.TAB (RR_ID, RR_SELECT_ID) SELECT RR_ID, RR_SELECT_ID, from DBO.TABETEMP Where Not Exists (Select Distinct RR_ID from DBO.TAB WHERE DBO.TAB.RR_ID = DBO.TABETEMP.RR_ID)
Update dbo.tab set detail_iscalled = feetemp.isspotcheckedfrom (selectpotcheckedfrom (selection id, questionpotchecked from tabetemp) as feetemp where dbo.tab.id = feetemp.id