SQL Query to get ToTime where max(EndMeasDepth) and min(ReportNo) and Min(SeqNo)

• Brian.Tran

  Old Hand

  Points: 344

  More actions

  October 3, 2019 at 2:58 pm

  #3685741

  Please help. The query is as far as I can get. Here is the query in txt format. Since the max(EndMeasDepth) is NULL or 0, I want to get the column [ToTime] with min(ReportNo) and min(SeqNO)

  Query:

  select D.wellid, min(ToTime) as [ToTime]from

  DailyOperations d

  INNER JOIN (select WellID, max(ISNULL(EndMeasDepth,0)) AS MaxEndMeasDepth

  from DailyOperations Group By WellID) DM on DM.WellID = D.WellID and

  DM.MaxEndMeasDepth = ISNULL(D.EndMeasDepth,0)

  where D.JobID ='Drilling' and D.wellid ='102193.01'

  GROUP BY D.WellID

  order by D.WellID

  

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  October 4, 2019 at 3:10 pm

  #3686067

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.