How to select a list of values without adding into table

• mail2vz

  SSC Enthusiast

  Points: 102

  More actions

  March 21, 2011 at 3:08 am

  #104050

  I want to generate a dynamic query by selecting a list of values. The list is generated by a dot net application.

  ex: list

  1. a.txt

  2. b.txt

  3. c.txt

  using this list i want to generate the dynamic quer insert into test ('a.txt'),insert into test ('b.txt'), insert into test ('c.txt') so on.

  is there any options available?

• srikant maurya

  Hall of Fame

  Points: 3293

  More actions

  March 21, 2011 at 3:25 am

  #1301154

  You can create procedure and list value pass to procedure as comm delimited

  create USP_Insert_table (@list varchar(8000)='a.txt,b.txt,c.txt')

  as

  begin

  insert into #table (text_name)

  select data from dbo.f_Split(',',@list) where data<>''

  end

  function dbo.f_Split will split the list data in tabular format