select distinct VNumber, FullName, StartDate, EndDate
--# (select top 1 FullName from tCustomer tC1 where tC1.VNumber = tCustomer.VNumber)
from tCustomer
  where Active = 1
order by 2, 1, 3
