SQL Server Performance

require a stored procedure

Discussion in 'General Developer Questions' started by threadsql, May 12, 2006.

  1. threadsql New Member

    hi i have a doubt again

    i have a field test1 which takes normally a firstname lastname combination field like a greeting
    ex: mr. harley davidson

    where in this case firstname is harley and lastname is davidson so this test1 filed is having data mr. harley davidson
    and firstname lastname fields are empty and have to fill the firstname lastname fields using this test1 field where in this

    cases firstname and lastname are null values

    see the following examples and please send me the procedure to build the following procedure to update those breaked

    firstname and lastname from test1 field and to be updated in the firstname and lastname and test1 and data also to b present

    conditions like these

    example1 Dr.jane1austine
    note:
    '1' is a single blankspace


    example2 Dr.1jane1 austine,jr

    EXAMPLE mr.r.waren1cookey
    example mr.r. waren1cookey,III
    example: mr.r.1waren1cookey,jr.
    example: Dr. george1v.huffmon1III
    example:Mr.1Bardley1E.Lackey
    exampe:Mr.Fred1A.1wragnerIII
    exampe:Mr.B.G.1Stogner
    example:Mr.Allen1P.1Hunt,Jr
    exampe:Mr1&1Mrs.1xyz
    example:Atlantel,Inc.












































    sql server
  2. Adriaan New Member

Share This Page