USE SELECT DISTINCT t1.siteID,t2.webID, t2.title [accessLevel],t3.tp_login,CONVERT(DECIMAL(6,2),((CONVERT(DECIMAL,t4.diskUsed)/1024)/1024)) [diskUsed MB], t6.fullUrl FROM DBO.RoleAssignment t1 JOIN DBO.roles t2 ON t2.siteID = t1.siteID AND t2.roleID =