sql - Selecting additional entry not in table without inserting to table -

i creating report in report builder 3.0. table filling dataset missing 1 entry all entry select in dropdown.

approach stored procedure returns in table plus additional entry.

limits not want insert additional entry in table compromise system use.

basically, how can i:

select * tablea

a-----------b

1-----------texta

2-----------textb

then without inserting table, return additional value stored procedure being:

0----------all

you can use union all

select a,b tablea union select 0,'all'