• Thanks for replying,

    I had another doubt

    After Running the below Select Statement what you given for example my records are like below,

    SELECT Name,

    MIN(case when Unit = 'tt' then ISNULL(Figure,0) end) as tt,

    MIN(case when Unit = 'm' then ISNULL(Figure,0) end) as m,

    MIN(case when Unit = 'ft' then ISNULL(Figure,0) end) as ft

    FROM TBL_SAMPLE

    group by name

    Name tt m ft

    ---------------------------------------

    ABC 20 10 NULL

    PQR 30 90 NULL

    XYZ 60 15 NULL

    Now my requirement is if ft = NULL then i want to do ( m/tt ) so now the total records i want to display is,

    Name tt m ft

    ---------------------------------------

    ABC 20 10 0.5

    PQR 30 90 3

    XYZ 60 15 0.25

    so this is my final result

    how to resolve this.

    Thanks in Advance.