Ruben12345 says:
SELECT sa.id, sa.shipment_no, v.vehicle_name, m.member_name, sa.begin_date_time, sa.create_date, sa.member_id, sa.partner_id, sa.vehicle_id, sa.end_date_time, sa.active
FROM dbo.shipment_assignment AS sa INNER JOIN
dbo.vehicles AS v ON v.vehicle_id = sa.vehicle_id INNER JOIN
dbo.members AS m ON sa.partner_id = m.member_id
replace above code with below
SELECT sa.id
,sa.shipment_no
,v.vehicle_name
,m.member_name
,sa.begin_date_time
,sa.create_date
,sa.member_id
,sa.partner_id
,sa.vehicle_id
,sa.end_date_time
,sa.active
, CONVERT(VARCHAR(5),DateDiff(dd, sa.begin_date_time, sa.end_date_time)) + ' Days '
+ CONVERT(VARCHAR(5),DateDiff(hh, sa.begin_date_time, sa.end_date_time) % 24) + ' hours '
+ CONVERT(VARCHAR(5),DateDiff(mi, sa.begin_date_time, sa.end_date_time) % 60) + ' minutes '
+ CONVERT(VARCHAR(5),(DATEDIFF(S, sa.begin_date_time, sa.end_date_time)%60))+' seconds' As TotalDiff
FROM dbo.shipment_assignment AS sa INNER JOIN
dbo.vehicles AS v ON v.vehicle_id = sa.vehicle_id INNER JOIN
dbo.members AS m ON sa.partner_id = m.member_id