Hassle-free live chat software re-imagined for business growth. 2 users, always free.
select ipkTripID,dStartTime,dEndTime,isnull(iMaxSpeed,0) as iMaxSpeed,isnull(iDistance,0) as iDistance,isnull(iAverageSpeed,0) as iAverageSpeed,tm.vpkDeviceID, A.vTextMessage as startLocation,nStartEventInst,nEndEventInst FROM tblTrip_Master tm inner join tblCommonTrackingData A on A.vSequenceID = tm.nStartEventInst
inner join tblCommonTrackingData A on A.vSequenceID = tm.nStartEventInst AND on A.vpkDeviceID = tm.vpkDeviceID
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!