query problem

• sandymca94

  Grasshopper

  Points: 21

  More actions

  November 25, 2008 at 5:13 am

  #203316

  i need total time interval between the problem occur and resolve and i am getting the number of time problem occur but total time not getting .for one problem in my table once problem occur and resolve so i am counting one problem.

  and my other query is for number of times problem occur is working fine but i need time also.........

  select count(*) as ProblemCount ,Ft.TagIndex, TagName from dbo.FloatTable as Ft join

  dbo.TagTable as TT on Ft.TagIndex= TT.TagIndex where val=0 group by Ft.TagIndex , TagName

  but one field is the same table DateAndTime in FloatTable .so i nedd total time also.

  Can any budy help me..........

  Thanks in advance....