quote:

---

SELECT @nHeat = Heat, @nRollMillBarID = LocSeq, @sProduct = FinalProd, @sLocation = Location FROM INSERTED

---

quote:

---

Let me ask, are you treating the trigger as a set based operation?

---

ALTER TRIGGER trgSR_CheckAndAddSampleRequest_Mill1
ON NYS1ReHeat FOR UPDATE
AS
BEGIN
	DECLARE @nHeat 		AS INT,
		@nRollMillBarID AS INT,
		@sProduct 	AS VARCHAR(20),
		@nSRCount 	AS INT,
		@sLocation 	AS VARCHAR(20)

--	SELECT @nHeat = Heat, @nRollMillBarID = LocSeq, @sProduct = FinalProd, @sLocation = Location FROM INSERTED
-- 	REMOVED. This only handled one row not multiple row

--	IF (@sLocation = 'REHEAT')
--	BEGIN
--		IF NOT EXISTS (SELECT * FROM Physicals WHERE Heat = @nHeat AND SQLProduct = @sProduct)
		IF NOT EXISTS (SELECT * FROM Physicals p inner join inserted i
					on	p.Heat		= i.Heat
					and	p.SQLProduct	= i.FinalProd)
		BEGIN
--			SELECT 	@nSRCount = COUNT(*)
--			FROM 	SampleRequest SR INNER JOIN NYS1Reheat Reheat 
--				ON 	SR.RollMillBarID = Reheat.LocSeq
--			WHERE 	Reheat.Heat 	= @nHeat 
--			AND 	Reheat.FinalProd = @sProduct 
--			AND 	(SR.SampleRequest = 1 OR SR.SampleCut=1)

			SELECT	@nSRCount = COUNT(*)
			FROM	inserted i inner join NYS1Reheat Reheat 
				on	i.Heat		= Reheat.Heat
				and	i.FinalProd	= Reheat.FinalProd
				inner join SampleRequest SR
				on	SR.RollMillBarID = Reheat.LocSeq
			WHERE	(SR.SampleRequest = 1 OR SR.SampleCut = 1)

			IF (@nSRCount < 2)
			BEGIN
--				INSERT INTO SampleRequest(RollMillBarID, SampleRequest, SampleCut, AutoRequest) VALUES(@nRollMillBarID, 1, 0, 1)
				INSERT INTO SampleRequest(RollMillBarID, SampleRequest, SampleCut, AutoRequest)
				SELECT	LocSeq, 1, 0, 1
				FROM	inserted
			END
		END
--	END
END