select distinct messageCode from tbl_GS1_BatchMessages with (nolock) where createDate between and union select 'UNRESOLVED BRAND' messageCode order by messageCode