• I figured out the solution.

    Original Query

    select 0, 'All'

    union

    Select statusid, statusdescription

    from status order by statusid

    Improved query

    select 0 as statusid , 'All' as statusdescription

    union

    Select statusid, statusdescription

    from status

    order by statusid