title: An Easy Way to Split multiple String using Transact-SQL
body: <p>I have 3 strings </p>
  
  <pre><code>@NameList = Hi|Hi1|Hi2
  @DESCLIST = Hii|Hii1|Hii2
  @SEQList = 1|2|3
  </code></pre>
  
  <p>I am looking for a Transact-SQL function where it can split these strings and insert in to table in below order</p>
  
  <pre><code>pkid  Name   DESC   Seq
  1     Hi     Hii    1
  2     Hi1    Hii1   2
  3     Hi2    Hii2   3
  </code></pre>