Hi,
just a quick question regarding to MEDIAN:

with x as (select 1.0 as a union all select 2.0 as a)
select sys.median(a) as result
from x

returns result=1
i would expect result=1.5 though

any suggestion?
thanks
milan