title: Display result Data in single Row ,No matter For no. of column in Sql server
body: <p>I have this Type of Query,</p>
  
  <pre><code>select StateName ,countryName
  from country_master left join state_master on country_master.countryID = state_master.countryID
  </code></pre>
  
  <p>which produce following result,</p>
  
  <blockquote>
    <p>Gujarat&nbsp; India<br> Delhi &nbsp;India<br>
    HR    &nbsp;&nbsp;&nbsp;India<br> MP  &nbsp;&nbsp;&nbsp;India<br>
    NY    &nbsp;&nbsp;&nbsp;USA<br> LA    &nbsp;&nbsp;&nbsp;USA<br>
    Chicago&nbsp; USA<br> WDC &nbsp;USA<br> London    &nbsp;Uk<br></p>
  </blockquote>
  
  <p>I want this result in single row with its relation like,</p>
  
  <blockquote>
    <p>India - &nbsp; Gujarat  &nbsp;Delhi &nbsp;  HR   &nbsp;    MP <br> USA
    - &nbsp;  NY&nbsp;    LA  &nbsp;Chicago    Uk  - &nbsp;&nbsp;  London</p>
  </blockquote>
  
  <p>Have Any Idea For Building this Query<br>
  Suggest Me,
  Thanks,</p>