Try again:

...

FOR UPDATE

AS

DECLARE @CustomerID int

IF @@ROWCOUNT =1

BEGIN

SELECT @CustomerID=CustomerID FROM INSERTED

EXEC dbo.CheckCustomerLevel @CustomerID

END

ELSE

BEGIN

SELECT IDENTITY(INT,1,1) ID,CustomerID INTO #TEMP FROM INSERTED ORDER BY CustomerID

DECLARE TEST_CUR CURSOR FOR SELECT CustomerID FROM #TEMP ORDER BY...

select name

from table1 a

where not exists(select 1 from table2 where id1=a.id and id2=a.id)

This script has a fault,that is,the results don't contain those tables which not exists any indexes.