Query Needed

• vs.satheesh

  SSCrazy

  Points: 2392

  More actions

  January 23, 2018 at 9:40 pm

  #402985

  Dear all

  In my stored procedure  input parameter is

  exec spName @Authorid='AAAAAA',@Exp=20,@Subject='101,102,103,104'

  I want to insert separate record for subject wise

  Authorid,Exp,Subject
  AAAAA || 20 || 101
  AAAAA || 20 || 102
  AAAAA || 20 || 103
  AAAAA || 20 || 104

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  January 23, 2018 at 10:24 pm

  #1977037

  DelimitedSplit8K is your friend.

  Happy reading. Happy learning.

• DesNorton

  SSC-Insane

  Points: 24387

  More actions

  January 23, 2018 at 10:40 pm

  #1977040

  Why not use a table-value type as a parameter.  Then you simply select from the parameter into the destination table

  ---

  How to post data/code on a forum to get the best help.