USP_DATALIST_CMSSECURITYGROUP

Lists CMS Security Groups.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(65)	IN	Name
@SITETASKSGROUP	bit	IN	Site Tasks Group
@NAMEUNIQUE	bit	IN	Name Unique

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CMSSECURITYGROUP
                (
                    @NAME nvarchar(65) = null,
                    @SITETASKSGROUP bit = null,
                    @NAMEUNIQUE bit = null
                )
                as
                    set nocount on;

                    IF (@NAMEUNIQUE > 0)
                    BEGIN
                        select ID,
                           NAME,
                           SITETASKSGROUP    
                        from dbo.CMSSECURITYGROUP
                        where NAME = @NAME
                    END
                    ELSE
                    BEGIN
                        select ID,
                               NAME,
                               SITETASKSGROUP    
                        from dbo.CMSSECURITYGROUP
                        where (@SITETASKSGROUP is null or SITETASKSGROUP = @SITETASKSGROUP)
                        and (@NAME is null or NAME like '%' + @NAME + '%')
                    END