Normalise not normalised data

• ip13791113

  Valued Member

  Points: 68

  More actions

  March 31, 2017 at 7:59 am

  #322590

  Hi all,

  is there any trick 22 to select from this table
  Testcase Table
  Test_ID   ReqID
  1             4711
  2             4711, 4712

  And receive this result:
  Req_ID  Test_ID
  4711        1
  4711        2
  4712        2 

  Thank you!

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  March 31, 2017 at 8:12 am

  #1935986

  ip13791113 - Friday, March 31, 2017 7:59 AM

  Hi all,

  is there any trick 22 to select from this table
  Testcase Table
  Test_ID   ReqID
  1              4711
  2             4711, 4712

  And receive this result:
  Req_ID  Test_ID
  4711        1
  4711        2
  4712        2 

  Thank you!

  Check the following article to get the function to do this.
  http://www.sqlservercentral.com/articles/Tally+Table/72993/

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2