dbo.ufnGetStock Function

Information

NameufnGetStock
TypeScalar
Created29.3.2010. 21:58:56

SQL Script

CREATE FUNCTION [dbo].[ufnGetStock](@ProductID [int])
RETURNS [int] 
AS 
BEGIN
DECLARE @ret int;

SELECT @ret = SUM(p.[Quantity]) 
FROM [Production].[ProductInventory] p 
WHERE p.[ProductID] = @ProductID 
AND p.[LocationID] = '6'; -- Only look at inventory in the misc storage

IF (@ret IS NULL) 
SET @ret = 0

RETURN @ret
END;