Convert common Separated number to # table

• ralahari

  SSC Veteran

  Points: 285

  More actions

  October 2, 2023 at 4:11 pm

  #4299782

  @reportParameter 1008,1009,1011,1014 values need to insert to #Table

  Note: @reportParameter is not returning values to db as string from report server

  Select * from

  STRING_SPLIT(1008,1009,1011,1014,',')

  Could you Please solution.

   

• ScottPletcher

  SSC Guru

  Points: 100812

  More actions

  October 2, 2023 at 4:13 pm

  #4299783

  The value needs to be a string:

  STRING_SPLIT('1008,1009,1011,1014',',')

  SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.