We are using SQL Server for QC. We have to export the entire test path for each test cases to an Excel Sheet. The Excel Report Generator gives me only the immediate parent folder name. I understand i have to write an inner loop SQL to get the entire path. I have found one post that gives sample SQL for Oracle database. But, we use SQL server and the SQL syntax that is available in the other post does not work for me. To be frank, i am not a SQL or DB admin guy. I am a test team leader have little knowledge about SQL. I can write simple SQL. So, is anyone can give me a sample SQL that works in SQL Server for this ? I appriciate your help.