ALTER PROCEDURE dbo.treeViewDefaultDir
        @ListOwner VARCHAR(200),
        @Roles     VARCHAR(2000)
     AS

--    SET @Roles = REPLACE(@Roles,'''','') --Uncomment if needed

 SELECT Distinct 
        gl.ListID, 
        gl.ListTitle, 
        gl.ListParent,
        gl.ListOwner
   FROM GroupList gl,
        GroupListShares gls
  WHERE gl.ListID = gls.ListReferencedID
    AND (
        ','+@Roles+',' LIKE '%,'+gls.SecurityGroupReferenceID+',%'
        OR
        gls.ListOwner = @ListOwner
        )
  ORDER BY gl.ListTitle

 RETURN

--===== Create and populate the Tally table on the fly
 SELECT TOP 11000 --equates to more than 30 years of dates
        IDENTITY(INT,1,1) AS N
   INTO dbo.Tally
   FROM Master.dbo.SysColumns sc1,
        Master.dbo.SysColumns sc2

--===== Add a Primary Key to maximize performance
  ALTER TABLE dbo.Tally
        ADD CONSTRAINT PK_Tally_N PRIMARY KEY CLUSTERED (N)

--===== Allow the general public to use it
  GRANT SELECT ON dbo.Tally TO PUBLIC

  ALTER PROCEDURE dbo.treeViewDefaultDir
        @ListOwner VARCHAR(200),
        @Roles     VARCHAR(2000)
     AS

--    SET @Roles = REPLACE(@Roles,'''','') --Uncomment if needed

--===== Prep the @Roles Parameter for "splitting"
    SET @Roles = ','+@Roles+','

 SELECT Distinct 
        gl.ListID, 
        gl.ListTitle, 
        gl.ListParent,
        gl.ListOwner
   FROM GroupList gl,
        GroupListShares gls,
        (--Derived table splits the input parameters in the @Roles variable so can join
         SELECT SUBSTRING(@Roles,N+1,CHARINDEX(',',@Roles,N+1)-N-1) AS Role
           FROM dbo.Tally WITH (NOLOCK)
          WHERE N < LEN(@Roles) 
                AND SUBSTRING(@Roles,N,1) = ','
        ) roles
  WHERE gl.ListID = gls.ListReferencedID
    AND (
        gls.SecurityGroupReferenceID = roles.Role
        OR
        gls.ListOwner = @ListOwner
        )
  ORDER BY gl.ListTitle

 RETURN