Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
Select a.dGPSDateTime ,a.vSequenceID From (select top 5 dGPSDateTime , vSequenceID from tblCommonTrackingData where vReportID = 8 AND CAST(vpkDeviceID as bigint)= 862193020453528 and dGPSDateTime >= '2014-12-17 17:06:33.000' --and not exists -- (select vpkDeviceID -- from tblTrip_Master -- where nEndEventInst = 913565) order by dGPSDateTime) as a
Where vSequenceID isn't 913565
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Running total between 2 sql tables in Sql||6||50|
|PHP - How to insert data using sqlsrv on stored procedure?||8||60|
|Restoring .bak and .trn files created by an unknown version of Microsoft SQL Server||7||46|
|how to use ROW_NUMBER() correctly||8||44|
Join the community of 500,000 technology professionals and ask your questions.