case 1:
select dbo.GetDescription(lvl_id,6),dbo.GetDescription(lvl_id,8)
from tblHierarchy
the result is ok:Area City.
case 2:
select dbo.GetDescription(lvl_id,6),dbo.GetDescription(lvl_id,8)
from tblHierarchy
group by dbo.GetDescription(lvl_id,6),dbo.GetDescription(lvl_id,8)
the result is wrong:Area Area
case 3:
select dbo.GetDescription(lvl_id,6),dbo.GetDescription(lvl_id,8)
from tblHierarchy
group by dbo.GetDescription(lvl_id,8),dbo.GetDescription(lvl_id,6)
the result is wrong:City City
P.S: The...