Post reply

T-SQL 2000

  • December 5, 2010 at 9:07 am

    #229845

    I import files into SQL 2000 DB that contain First Name Last Name. Recently a a file came in that had FN and LN reversed. A visual check of the file did not catch this.

    Would like suggestion on how to detect a "wrong" name type in a column?

  • 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

  • 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]

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply