• hi thank you very much for your inputs. Ireally appreciate your response.

    Finaly i get rid of this mess by using PIVOT table in slq server as below.

    select ServerName,

    SYBASE, MQ, [CITRIX FARM],

    Oracle, [UDB DW],CITRIX, IHS, WAS, IIS, UDB,[.NET],[SQL SERVER]

    from

    (

    SELECT

    ServerName,

    Adder_Name,

    Adder_ver

    FROM tableA

    ) d

    pivot

    (

    Max(Adder_ver)

    for Adder_Name in (SYBASE, MQ, [CITRIX FARM],

    Oracle, [UDB DW],CITRIX, IHS, WAS, IIS, UDB,[.NET],[SQL SERVER])

    ) piv