USE [LABORATORY]
GO
/****** Object:  StoredProcedure [dbo].[Lab_CheckInstrumentExam]    Script Date: 10/29/2020 4:30:12 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[Lab_CheckInstrumentExam]
@RequestNum as varchar(10)

AS
SET NOCOUNT ON

select I.ItemId
from LABORATORY..tbLabMaster L
	Inner join LABORATORY..tbLabInstrumentExams I
		on L.ItemID = I.ItemID
where L.requestNum = @RequestNum
	and L.SectionID = 'SER'