Trying to add a business rule after import

Trying to add the following business rule to update after import.

set @TimesIn = (select Count(a.SerialNo)
FROM ServiceRequestAddFru a
inner join Frus b
on a.FrusID = b.FrusID
where b.PartNumber=@FrusPartNumber and
a.CustomerID=@CustomerID and a.SerialNo=@SerialNo
and @FrusRepairable=1 and a.ShipDate >= DATEADD(yy, -1, GETDATE()))
---
if (select Count(a.SerialNo)
from ServiceRequestAddFru a
inner join Frus b
on a.FrusID = b.FrusID
where b.PartNumber=@FrusPartNumber and a.CustomerID=@CustomerID and
a.SerialNo=@SerialNo and b.Repairable=1 and
a.ShipDate >= DATEADD(month, -3, GETDATE())) > 0
begin
set @OrderTypeID = 4
end

How can I accomplish this like when you do a createForm1 and editForm1? It needs to update the rows like how you manually enter the rows.
1 person has
this question
+1
Reply