fnFormTitleIsOK

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@FormTitle nvarchar(200) IN
@ClientSitesID int IN

Definition

Copy

            CREATE FUNCTION [dbo].[fnFormTitleIsOK](@FormTitle nvarchar(200), @ClientSitesID int)
            RETURNS uniqueidentifier
            AS 
            BEGIN
                RETURN (
                    SELECT A.[Guid] 
                    FROM dbo.CustomFormElement A
                    INNER JOIN dbo.CustomFormSettings B ON A.[Guid] = B.[FormGuid]
                    WHERE B.[ClientSitesID] = @ClientSitesID AND A.[Title] = @FormTitle AND A.[TypeID] = 1
                )
            END