title: T-SQL function to split string with two delimiters as column separators into table
body: <p>I'm looking for a t-sql function to get a string like:</p>
  
  <blockquote>
    <p>a:b,c:d,e:f</p>
  </blockquote>
  
  <p>and convert it to a table like</p>
  
  <pre><code>ID     Value
  
  a      b
  
  c      d
  
  e      f
  </code></pre>
  
  <p>Anything I found in Internet incorporated single column parsing (e.g. XMLSplit function variations) but none of them letting me describe my string with two delimiters, one for column separation &amp; the other for row separation.</p>
  
  <p>Can you please guiding me regarding the issue? I have a very limited t-sql knowledge and cannot fork those read-made functions to get two column solution?</p>