http://dbshelp.devio.at/index.php?action=history&feed=atom&title=Dbo.ufnGetSalesOrderStatusTextfunction 2026-06-03T09:48:09Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=Dbo.ufnGetSalesOrderStatusTextfunction&diff=2554&oldid=prev 2010-06-23T22:07:44Z

<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.ufnGetSalesOrderStatusText |- valign=&quot;top&quot; | &#039;&#039;&#039;Descriptio...</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.ufnGetSalesOrderStatusText<br /> |- valign=&quot;top&quot;<br /> | '''Description<br /> | Scalar function returning the text representation of the Status column in the SalesOrderHeader table.<br /> |}<br /> <br /> === Source ===<br /> &lt;pre&gt;<br /> CREATE FUNCTION [dbo].[ufnGetSalesOrderStatusText](@Status [tinyint])<br /> RETURNS [nvarchar](15) <br /> AS <br /> -- Returns the sales order status text representation for the status value.<br /> BEGIN<br /> DECLARE @ret [nvarchar](15);<br /> <br /> SET @ret = <br /> CASE @Status<br /> WHEN 1 THEN 'In process'<br /> WHEN 2 THEN 'Approved'<br /> WHEN 3 THEN 'Backordered'<br /> WHEN 4 THEN 'Rejected'<br /> WHEN 5 THEN 'Shipped'<br /> WHEN 6 THEN 'Cancelled'<br /> ELSE '** Invalid **'<br /> END;<br /> <br /> RETURN @ret<br /> END;<br /> &lt;/pre&gt;</div>

Bot