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....