(SELECT STUFF((SELECT ',' + LTRIM(RTRIM(D.VehicleID)) FROM JDSN.OrderVehicle D
WHERE D.OrgID=@OrgID AND D.OrderID=A.OrderID
FOR XML PATH('')), 1, 1, '')) AS VehicleIDs,
(SELECT STUFF((SELECT ',' + LTRIM(RTRIM(D.VehicleID)) FROM JDSN.OrderVehicle D
WHERE D.OrgID=@OrgID AND D.OrderID=A.OrderID
FOR XML PATH('')), 1, 1, '')) AS VehicleIDs,