这是表示/格式问题,而不是数据检索问题。
但是,如果您确实遇到这个问题,可以这样做…
注意: 测试,您可能需要使用LEAD而不是LAG
SELECT
Chauffeur = CASE WHEN X.prevsecurysatnr = X.securysatnr THEN '' ELSE X.Chauffeur END,
securysatnr = CASE WHEN X.prevsecurysatnr = X.securysatnr THEN '' ELSE X.securysatnr END,
X.Datum,
X.LaadUur,
X.LotNr,
X.RitInfo
FROM
(
SELECT
LAG(t.securysatnr) OVER (ORDER BY ISNULL(d.FirstName, '') + ' ' + isnull(d.LastName, ''), convert(date, p.PlanningDate), p.StartTime) AS prevsecurysatnr,
ISNULL(d.FirstName, '') + ' ' + isnull(d.LastName, '') as Chauffeur,
t.securysatnr,
convert(date, p.PlanningDate) as Datum,
p.StartTime as LaadUur,
r.LotNr,
isnull(pFrom.City, '') + ' - ' + isnull(pTo.City, '') as RitInfo
from
tblPlanning p
left outer join vwRit r on p.RitID = r.RitID
left outer join tblPlace pFrom on r.VertrekID = pFrom.PlaceID
left outer join tblPlace pTo on r.BestemmingID = pTo.PlaceID
inner join tblDriver d on p.DriverID = d.DriverID
inner join tblTruck t on p.TruckID = t.TruckID
where convert(date, p.PlanningDate) = convert(date, getdate())
) X
order by
X.Chauffeur, X.Datum, X.LaadUur