Dbo.ufnGetDocumentStatusText (function) - Revision history

Bot at 21:59, 23 June 2010

2010-06-23T21:59:41Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:17Z

Bot at 21:56, 28 December 2009

2009-12-28T21:56:28Z

Bot at 06:01, 30 November 2009

2009-11-30T06:01:44Z

Bot at 05:26, 30 November 2009

2009-11-30T05:26:23Z

Bot at 22:59, 26 November 2009

2009-11-26T22:59:56Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''function | dbo.ufnGetDocumentStatusText |- |}

 CREATE FUNCTION [dbo].[ufnGetDocu...

2009-01-03T12:36:00Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''function | dbo.ufnGetDocumentStatusText |- |} <pre> CREATE FUNCTION [dbo].[ufnGetDocu...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''function
| dbo.ufnGetDocumentStatusText
|-
|}

<pre>
CREATE FUNCTION [dbo].[ufnGetDocumentStatusText](@Status [tinyint])
RETURNS [nvarchar](16)
AS
-- Returns the sales order status text representation for the status value.
BEGIN
DECLARE @ret [nvarchar](16);

SET @ret =
CASE @Status
WHEN 1 THEN N'Pending approval'
WHEN 2 THEN N'Approved'
WHEN 3 THEN N'Obsolete'
ELSE N'** Invalid **'
END;

RETURN @ret
END;
</pre>

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Function
 | dbo.ufnGetDocumentStatusText
@@ Line 8: / Line 8: @@
 | '''Description
 | Scalar function returning the text representation of the Status column in the Document table.
 |}
 === Source ===

@@ Line 34: / Line 34: @@
 | dbo.ufnGetDocumentStatusText
 |- valign="top"
 | '''Description
 | Scalar function returning the text representation of the Status column in the Document table.
 |-
 |}

@@ Line 27: / Line 27: @@
 END;
 </pre>
 == automatically generated ==
@@ Line 34: / Line 33: @@
 | '''function
 | dbo.ufnGetDocumentStatusText
-|-
+|- valign="top"
 | '''Description

@@ Line 9: / Line 9: @@
 <pre>
 CREATE FUNCTION [dbo].[ufnGetDocumentStatusText](@Status [tinyint])
 RETURNS [nvarchar](16)