title: How to do Fold in T-SQL?
body: <p>If I have data in the following format</p>
  <pre><code> id    subid      text
   1     1          Hello
   1     2          World
   1     3          !
   2     1          B
   2     2          B
   2     3          Q
  </code></pre>
  <p>And would like it in this format:</p>
  <pre><code> id  fold
   1   HelloWorld!
   2   BBQ
  </code></pre>
  <p>How could I accomplish it in T-SQL?</p>