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