query problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Dr. Diana Dee » query problem

query problem

Rate Topic

Display Mode

Topic Options

Author

Message

sandymca94

Posted Tuesday, November 25, 2008 5:13 AM

Forum 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 »

Permissions