Cric per rally

select distinct cast(a8 as float) from [dbo].[nccat4_xcattab_crick] x inner join [dbo].[nccat4_Product] p on p.code=x.code inner join [dbo].[nccat4_xcattab_global] g on g.code=p.code left outer join nccat4_stock s on s.code=p.code where isnull(a8,'')<>'' and p.type=0 AND g.mnu='MENU2_EJA' ORDER BY cast(a8 as float)