http://dbshelp.devio.at/index.php?action=history&feed=atom&title=Dbo.ufnGetStockfunction 2026-05-01T14:39:34Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=Dbo.ufnGetStockfunction&diff=2555&oldid=prev 2010-06-23T22:07:45Z

<p>New page: == wikibot == {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot; |- valign=&quot;top&quot; | &#039;&#039;&#039;Function | dbo.ufnGetStock |- valign=&quot;top&quot; | &#039;&#039;&#039;Description | Scalar func...</p> <p><b>New page</b></p><div>== wikibot ==<br /> <br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- valign=&quot;top&quot;<br /> | '''Function<br /> | dbo.ufnGetStock<br /> |- valign=&quot;top&quot;<br /> | '''Description<br /> | Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.<br /> |}<br /> <br /> === Source ===<br /> &lt;pre&gt;<br /> CREATE FUNCTION [dbo].[ufnGetStock](@ProductID [int])<br /> RETURNS [int] <br /> AS <br /> -- Returns the stock level for the product. This function is used internally only<br /> BEGIN<br /> DECLARE @ret int;<br /> <br /> SELECT @ret = SUM(p.[Quantity]) <br /> FROM [Production].[ProductInventory] p <br /> WHERE p.[ProductID] = @ProductID <br /> AND p.[LocationID] = '6'; -- Only look at inventory in the misc storage<br /> <br /> IF (@ret IS NULL) <br /> SET @ret = 0<br /> <br /> RETURN @ret<br /> END;<br /> &lt;/pre&gt;<br /> <br /> === References ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Dependency Type<br /> | '''Object Type<br /> | '''Referenced Object<br /> <br /> |- valign=&quot;top&quot;<br /> | Select<br /> | Table<br /> | [[Production.ProductInventory_(table)|Production.ProductInventory]]<br /> <br /> |}</div>

Bot