USP_CUSTOMFORMNOTIFICATION_GETUSERSROLES

            create procedure dbo.USP_CUSTOMFORMNOTIFICATION_GETUSERSROLES (
                @GUIDS nvarchar(4000), 
                @ClientsID int
            )
            as
            begin

                select [Guid], [name] from dbo.ClientRoles    
                where [ClientsID] = @ClientsID and [Deleted] = 0 
                and [Guid] in (select * from [dbo].[fnMakeGuidsTableFromString](@GUIDS, ','))

                union

                select [Guid], [FirstName] + ' ' + [LastName] + ' (' + [UserName] + ')' from dbo.ClientUsers 
                where [ClientsID] = @ClientsID and [Deleted] = 0 AND [active] = 1 
                and [Guid] in (select * from [dbo].[fnMakeGuidsTableFromString](@GUIDS, ','))

            end