fnClientAppTaskPrivs

            CREATE      FUNCTION [dbo].[fnClientAppTaskPrivs]
            (
            @ClientsID int,
            @ClientRolesID int
            )

            RETURNS @Tasks TABLE (
            ID int PRIMARY KEY,
            Guid uniqueidentifier,
            Name nvarchar(50),
            Description nvarchar(100),
            ParentID int,
            Seq int,
            canview bit,
            canedit bit,
            canadd bit,
            candelete bit,
            cansecure bit,
            OverridingGuid uniqueidentifier
            )
            AS
            BEGIN
            INSERT INTO @Tasks
                SELECT AppTasks.ID,AppTasks.Guid,AppTasks.Name,AppTasks.Description,AppTasks.ParentID,AppTasks.Seq,
                        isnull(ROP.canview,1), isnull(ROP.canedit,0),  isnull(ROP.canadd,0), isnull(ROP.candelete,0),  isnull(ROP.cansecure,0),AppTasks.OverridingGuid
                FROM dbo.ApplicationTasks AppTasks
                LEFT OUTER JOIN dbo.RoleObjectPrivs ROP on ROP.ClientRolesID = @ClientRolesID and ROP.ObjectGuid = AppTasks.Guid

            RETURN
            END