Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
( SELECT SerializedAssets.SerialNumber, Max(JobDownholeEquipment.JobID) AS LastOfJobID, Max(JobDownholeEquipment.StartTime) AS MaxOfStartTime, 'Job' AS JobType, Job.Company,Job.Rig,Job.RigNumber,Job.WellName,Job.City,Job.State FROM SerializedAssets INNER JOIN JobDownholeEquipment ON SerializedAssets.SerialNumber = JobDownholeEquipment.ToolNumber INNER JOIN Job ON Job.JobID = JobDownholeEquipment.JobID GROUP BY SerializedAssets.SerialNumber ) UNION ( SELECT ToolAssemblies.ToolNumber, MAX(ToolAssemblies.Location) AS LastOfLocation, Max(ToolAssemblies.UploadTime) AS MaxOfUploadTime, 'Assembly' AS JobType, "" AS Company,"" AS Rig,"" AS RigNumber,"" AS WellName,"" AS Cist,"" AS State FROM ToolAssemblies GROUP BY ToolAssemblies.ToolNumber )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL SERVER 2008 R2 Problem copying database||10||69|
|How to capture server information using powershell||3||60|
|SQL - Update field value based on two other fields in same table.||13||43|
|Importing from CSV to SSMS||2||7|
Join the community of 500,000 technology professionals and ask your questions.