T-SQL 2000

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  December 5, 2010 at 10:30 am

  #1258821

  Unless the names have a pattern it would be difficult to define any logic.

  This question should have been posted in the SQL Server 2000 forum here

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• LutzM

  SSC Guru

  Points: 107049

  More actions

  December 5, 2010 at 11:40 am

  #1258825

  How do you determine first name and last name?

  Are the column names part of the files?

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• Abhijeet Chavan

  SSCommitted

  Points: 1511

  More actions

  December 14, 2010 at 5:32 am

  #1262129

  XML can help u in this.

  Get those external files in XML if possible. As in xml u can tag the values. this will definitely solve your problem.