USE [LABORATORY]
GO
/****** Object:  StoredProcedure [dbo].[lab_getReagentInfo]    Script Date: 10/29/2020 4:28:46 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--Created by Jetty P. Omo
--To get the reagent Information
--March 29,2007
-- =============================================
ALTER    PROCEDURE [dbo].[lab_getReagentInfo]
	
	@StrItemCode as varchar(10)
as

select R.*, A.ItemName,B.Locationid,Reagent.Reagent
	from inventory..tbInvMaster as A 
		Inner Join inventory..tbInvent as B
        		On A.ItemID = B.ItemID and B.LocationID = '214'
		Left Outer Join  LABORATORY..tbLabBuildReagent R
			ON R.ReagentCode = A.ItemID
		Left Outer Join Build_file..TbCoLabReagents Reagent
			ON Reagent.Reagentcode = R.MachineCode
	WHERE  ItemCode = @strItemCode
/*
select  

	max(R.ItemCode) as ItemCode,
	max(R.ReagentCode) as ReagentCode,
	max(R.Quantity) as Quantity,
	max(R.TransDate) as TransDate,
	max(R.MachineCode) as MachineCode,
	max(A.ItemName) as ItemName,
	max(B.Locationid) as Locationid,
	max(Machine.MachineDescription) as MachineDescription

	from inventory..tbInvMaster as A 
		--Inner Join inventory..tbInvent as B
		Left Outer Join inventory..tbInvent as B
        		On A.ItemID = B.ItemID and B.LocationID = '25'
		Left Outer Join  LABORATORY..tbLabBuildReagent R
			ON R.ReagentCode = A.ItemID
		Left Outer Join LABORATORY..tbBuildInvMachine Machine
			ON Machine.MachineCode = R.MachineCode
	WHERE  ItemCode = @strItemCode
	Group by Machine.MachineCode
*/