UFN_QTRANSLATE_STATE_GETDESCRIPTION

This function returns the description for a given state.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_QTRANSLATE_STATE_GETDESCRIPTION(@ID uniqueidentifier) returns nvarchar(100) with execute as caller
            AS
            --Used by AdHocQuery and SmartQuery

            BEGIN
                declare @DESCRIPTION nvarchar(100)

                select @DESCRIPTION = DESCRIPTION        
                from dbo.STATE where ID = @ID

                RETURN @DESCRIPTION
            END