title: How to get path of a document using sql server 2012
body: <p>I am using an document management application which uses SQL Server 2012.</p>
  
  <p>I am trying to fetch document names along with its path. For example,</p>
  
  <p>If my document name is test.txt and it is under folder structure A/B/C, my output should be A/B/C/test.txt.</p>
  
  <p>Could anyone please help me with a query?</p>
  
  <p>Table name: DTree</p>
  
  <p>DataId     Name
  =======  ========</p>
  
  <p>12345     test.txt</p>