Does anyone know how to call a "Stored Procedure" from the "Events" module to send it the iMIS "ID" and receive a "value" in return.

Please see a very simple "Stored Procedure" below that would likely need to be called something like:

exec p_JDS_TEST iMIS_ID, 'return value'

 The iMIS "Events" module would then process the value "return value" accordingly.

ALTER

PROCEDURE [dbo].[p_JDS_TEST]@ID VARCHAR(10), VARCHAR(5) OUTPUT

SET NOCOUNT ON;

SELECT @REGISTRANT_CLASS = CASE A.INSURED WHEN 'TRUE' THEN 'INS' ELSE 'UNINS' END FROM dbo.SHSC_DATA AS A WHERE A.ID = @ID

END

Any ideas on how to make this work would be appreciated.

Thanks.

JDS

@REGISTRANT_CLASS

AS

BEGIN