title: create sql view from comma separated values
body: <p><strong>T-sql question</strong>:
  I need help to build a join from 2 tables, where on one of the tables I have aggregated data (comma separated values).</p>
  
  <p>I have a table - Users where I have 3 columns: UserId, DefaultLanguage and OtherLanguages.</p>
  
  <p>The table looks like this:</p>
  
  <pre><code>UserId  | DefaultLanguage  |  OtherLanguages
  ---------------------------------------------
     1    |      en          |       NULL
     2    |      en          |       it, fr
     3    |      fr          |       en, it
     4    |      en          |       sp
  </code></pre>
  
  <p>and so on.</p>
  
  <p>I have another table where I have the association between language code (en, fr, ro, it, sp) and language name:</p>
  
  <pre><code> LangCode  | LanguageName
  -------------------------
      en     | English
      fr     | French
      it     | Italian
      sp     | Spanish
  </code></pre>
  
  <p>and so on.</p>
  
  <p>I want to create a view like this:</p>
  
  <pre><code>UserId  | DefaultLanguage  |  OtherLanguages
  ---------------------------------------------
     1    |    English       |    NULL
     2    |    English       |    Italian, French
     3    |    French        |    English, Italian
     4    |    English       |    Spanish
  </code></pre>
  
  <p>and so on.</p>
  
  <p>In short, I need a view where the language code is replaced by language name. </p>
  
  <p>Any help, please?</p>