----------------------------------------------------------
CREATE FUNCTION Reports.fTotalDev(@LotID VARCHAR(15))

 RETURNS  @FailsTable TABLE(LeftFails INT,RightFails INT)
 
AS
BEGIN
	
DECLARE @LeftDevice INT,@RightDevice INT
DECLARE @LeftFails INT,@RightFails INT

SET @LeftDevice = (SELECT TOP 1 DeviceID FROM Tests.Registry WHERE LotID = @LotID ORDER BY DeviceID ASC)

IF (SELECT COUNT((SELECT DISTINCT DeviceID FROM Tests.Registry WHERE LotID = @LotID))) > 1
 BEGIN
  SET @RightDevice = (SELECT TOP 1 DeviceID FROM Tests.Registry WHERE LotID = @LotID ORDER BY DeviceID DESC)
 END

SET @LeftFails = (SELECT COUNT(Id) FROM Tests.Registry WHERE  Fail = 'DEV' AND LotID = @LotID AND DeviceID = @LeftDevice)
SET @RightFails = (SELECT COUNT(Id) FROM Tests.Registry WHERE  Fail = 'DEV' AND LotID = @LotID AND DeviceID = @RightDevice)

INSERT INTO @FailsTable (LeftFails,RightFails) VALUES (@LeftFails,@RightFails ) 
	
RETURN @FailsTable

END
GO
----------------------------------------------------------

Msg 137, Level 15, State 2, Procedure fTotalDev, Line 24
Must declare the scalar variable "@FailsTable".