Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

query problem Expand / Collapse
Author
Message
Posted Tuesday, November 25, 2008 5:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 30, 2009 4:55 AM
Points: 1, Visits: 14
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....
Post #608231
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse