I have numerous permissions reports that are based on Oracle using the Connect By Prior statement which unfortunately is proprietary to Oracle. I have the need to configure similar reports in SQL Server and was wondering if anyone has had luck in configuring any reports using the WITH statement since that's a SQL standard. I've attached one of the equivalent LiveReports that I use on Oracle. Any help would be greatly appreciated!
