USE [LABORATORY]
GO
/****** Object:  StoredProcedure [dbo].[Lab_BF_SearchInterpretation]    Script Date: 10/15/2020 2:58:34 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[Lab_BF_SearchInterpretation]
	@ExamId varchar(4)
AS

Select Code,
	IsNull(ExamId,'') as ExamId,
	IsNull(Interpretation,'') as Interpretation,
	Status,
	isComment,
	isNormalValue,
	isMethod,
	isInterpretation
From tbLab_BuildInterpretations
Where ExamId = @ExamId and Status = '1';