Mile Higher Than Sea Level (6/19/2014)

---

Thanks! I didn't think about that. (where is my V8 icon).

I was busy cobbling this together when you responded.

The Rule Engine components are designed to return each of the 100 Base Rules as a True - False based on Query criteria.

Let me try that out and come back to mark it as an anwser.

CREATE FUNCTION dbo.Rule71(@ID_Wells int) RETURNS int

AS

BEGIN;

DECLARE @Result int;

SET @Result = SELECT COUNT(*) AS "SELECT Wells.ID_Wells, Wells.Well_Name, Wells.ClassificationID FROM Wells WHERE (((Wells.ID_Wells)=" & @ID_Wells & ") AND ((Wells.ClassificationID)=3));

IF @Result = 0

Return 0; -- False

else

Return 1; -- True

end;

END;

go

SELECT R_71, dbo.Rule71(ID_Wells) AS Rule71

FROM dbo.StatusTable;