Home Forums SQL Server 2008 T-SQL (SS2K8) I need to compare and split the string and then save it in the detail_tb but dont know how ? RE: I need to compare and split the string and then save it in the detail_tb but dont know how ?

  • September 28, 2012 at 3:49 am

    #1543281

    code resolve my problem regarding insertion except it split Luman i.e. 0.372 value from string and saved in mcompraser column i.e. 1 in given string,and shows null in mluman colum in table :

    OUTPUT:

    Idmnorth meast mtimemheight mtemperaturemvoltagemcompraser mluman

    6 2449.555 06704.67880701071 44.678 11.7640.372 NULL

    7 2449.555 06704.67880701071 44.678 11.7640.372 NULL

    Message :

    (8 row(s) affected)

    Warning: Null value is eliminated by an aggregate or other SET operation.

    (1 row(s) affected)