SELECT MimeType,
SUM(DataSize)/1024 as Total_Size_MB,count(DocID) as Total_No_Doc FROM DVersData group by MimeType

SELECT  DocID
           , MAX([Version]) AS [MaxVersion]
    FROM    dversdata (nolock)
    GROUP

JOIN SubFolders  AS M
          ON D.ParentID= M.dataid OR -D.ParentID= M.dataid

WITH SubFolders(dataID,ParentID,Name,Comment,SubType,Unit,lvl)
AS
( 
  -- Anchor Member (AM)
  SELECT DataID ,ParentID,Name,DComment,
    Subtype,(select name from llirimsuser.DTree(nolock) where dataid=ownerid) as 'Unit', 
   0
  FROM llirimsuser.DTree (nolock)
  WHERE DataID =  28264085
  UNION

WITH SubFolders(dataid,name,SubType,lvl)
AS
( 

  -- Anchor Member (AM)
  SELECT dataid, Name,subtype, 0
  FROM llirimsuser.DTree (nolock)
  WHERE dataid = 28264085
  UNION ALL 
  -- Recursive Member (RM)
  SELECT D.DataID,D.Name,D.SubType,M.lvl+1
  FROM llirimsuser.DTree (nolock)  AS