title: Generate string from SQL Query
body: <p>I have following query:</p>
  
  <pre><code>SELECT ChallanNo+'-'+CONVERT(VARCHAR(12),ChallanDate,106) 
     FROM Challan WHERE ChallanID IN 
     (SELECT ChallanID FROM ChallanDetail WHERE PTUID=42192)
  </code></pre>
  
  <p>This query result will be : </p>
  
  <pre><code>151468-29 May 2012
  151591-31 May 2012
  </code></pre>
  
  <p>Now I need a string like this : </p>
  
  <pre><code>151468-29 May 2012, 151591-31 May 2012
  </code></pre>
  
  <p>Thanks for response</p>