title: SQL Select stuff
body: <p>I have <code>project</code> table.</p>
  
  <p>This is my query which is fetching following results.</p>
  
  <pre><code>select top 5 proj_ID, Proj_NM 
  from project
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>proj_ID Proj_NM  
  -------------------
   20     test1
   21     test2
   22     test3
   24     test4
   25     test5
  </code></pre>
  
  <p>I want to get this output instead. Can any one pls help.</p>
  
  <pre><code>proj_ID Proj_NM  All_Proj_NM
  ---------------------------------
   20     test1    test1,test2,test3,test4,test5
   21     test2    test1,test2,test3,test4,test5  
   22     test3    test1,test2,test3,test4,test5
   24     test4    test1,test2,test3,test4,test5
   25     test5    test1,test2,test3,test4,test5
  </code></pre>