Difference between revisions of "Dbo.ufnGetDocumentStatusText (function)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''function | dbo.ufnGetDocumentStatusText |- |} <pre> CREATE FUNCTION [dbo].[ufnGetDocu...) |
(No difference)
|
Revision as of 13:36, 3 January 2009
wikibot
| function | dbo.ufnGetDocumentStatusText |
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;
