Here are 2 triggers which are applied on table.

ALTER TRIGGER Cis_OP_No_Trigger1

ON dbo.Cis_OP_No

FOR INSERT, UPDATE

AS

IF (UPDATE (N_Vyrobok) or UPDATE (N_Kplan))

update Cis_OP_No set N_Vyrobok2 = (select ( i.N_Vyrobok + '/' +i.N_KPlan) from Cis_OP_No p inner join inserted i on p.N_ID = i.N_ID)

from Cis_OP_No p inner join inserted i on p.N_ID = i.N_ID

ALTER TRIGGER Cis_OP_No_Trigger2

ON dbo.Cis_OP_No

FOR INSERT, UPDATE

AS

IF UPDATE (N_Cas100ks)

update Cis_OP_No set N_KS_Hod = (select (((450/i.N_Cas100ks)*100)/8) from Cis_OP_No p inner join inserted i on p.N_ID = i.N_ID)

from Cis_OP_No p inner join inserted i on p.N_ID = i.N_ID

Table Cis_OP_No:

N_ID int

N_Cas100ks float

N_Vyrobok nvarchar

N_Kplan nvarchar

N_KS_Hod int

N_vyrobok2 nvarchar

N_rucne int

N_ID N_Cas100ks N_vyrobok N_kplan N_KS_Hod N_Vyrobok2 N_rucne

1----------5.73----------456000------001------982-------------456000/001---0

2----------5.73----------123000------001------982-------------123000/001---0

3----------7.71----------888000------003b-----730-------------888000/003b--0

ALTER Procedure dbo.UPdata

(

@e_Nplan char(20),

@e_Ncas char(20)

)

As

Update Cis_OP_NO

SET N_Cas100ks = convert(float,replace(@e_Ncas,',','.'))

Where N_Kplan = @e_Nplan

return

Error message:

Subquery returned more than 1 value. This is not premitted when the subquery follows =, =! , ....

Thank you