fnCategoryFolderIDInUseByProfilePhotoForm

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@ClientSitesID	int	IN
@CategoryFolderID	int	IN
@CurrentContentID	int	IN

Definition

Copy



            CREATE FUNCTION dbo.fnCategoryFolderIDInUseByProfilePhotoForm
            (
                @ClientSitesID int,
                @CategoryFolderID int,
                @CurrentContentID int
            )
            RETURNS bit
            AS
            BEGIN
                DECLARE @InUse bit

                SET @InUse = 0
                IF EXISTS (
                    SELECT TOP 1 pp.CategoryFolderID 
                      FROM dbo.SiteProfilePhotoForm pp 
                     INNER JOIN dbo.SiteContent c ON pp.ContentID = c.ID 
                     WHERE c.ClientSitesID = @ClientSitesID
                       AND pp.CategoryFolderID = @CategoryFolderID
                       AND pp.ContentID <> @CurrentContentID
                    )
                BEGIN
                    SET @InUse = 1
                END

                RETURN @InUse
            END