How to Send data line by line to a Text File ?

• mamidimahesh-127681

  SSC Eights!

  Points: 868

  More actions

  June 18, 2004 at 6:35 am

  #83241

  Hi,

  My Requirement:

  I have a result set.  From the result set i will take a record and i need to do some data manipulation and should send that data to text file.  And again second record, manipulating second record data, sending to text file. 

  Like that all records should be manipulated and need to sent to Text File. 

  I know sending bunch of records to text file.

  How to do this ?  Please help me.......

  Bobby

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  June 18, 2004 at 7:06 am

  #511013

  The following are some different ways of doing this

  1.)  Create a temp table with processed flag and walk it to return the 1st unprocessed record using set-based processing

  2.)  Create a cursor and walk the recordset

  3.)  Use VB or some or programming language return the recordset to it and have it walk the data

  just some suggestions

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net