concat sql more than 8kb

• ashutosh_samarth

  SSC Rookie

  Points: 34

  More actions

  March 11, 2005 at 5:43 am

  #66065

  Hi,

  I want to form a string out of a column for all records satisfying a particular criteria, this string is to be put into a file.

  declare @X24Text varchar(8000)

  Select  @X24Text = @X24Text + col1

  FROM  table1 where col2 = '100'

  The problem is that the concatenated string size can be more than 8kb. How do I deal with this problem ?

  I have defined this as a step in dts, so if there are any alternatives in dts are also welcome.

  Thanks in Advance

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  March 11, 2005 at 7:17 am

  #546604

  I think you'll have to use an activeX script to do this in the dts... You'll be able to use a sring and won't have any length limit.