I need to return a qry in QA that produces the following and am finding it
difficult I am new at this so I may not put it as clearly as I should.
The table holds ping responses from an iis box to its nearest router and I
am trying to return uptime of iis server and some statistics.
Return a qry in QA that retrieves the following.
Return one row per day for the current month , with the following
Total Count of conStatusCode
Percentage returned of conStatusCode = 0 against all other codes for that
Average conTimeMS for each day
something like this,.
conDate, totcount , percentage, avgms
1/1/2004, 143 , 98, 32
2/1/2004, 140 , 98, 31
3/1/2004, 138 , 98, 35
any help with this would be appreciated.
'**** table structure below
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[tblConnection1]') and OBJECTPROPERTY(id, N'IsUserTable')
drop table [dbo].[tblConnection1]
CREATE TABLE [dbo].[tblConnection1] (
[conDate] [datetime] NULL ,
[conSiteName] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
[conResponse] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL ,
[conIpNumber] [nvarchar] (20) COLLATE Latin1_General_CI_AS NULL ,
[conBuffSize] [int] NULL ,
[conTimeMS] [int] NULL ,
[conTTL] [int] NULL ,
[conStatusCode] [int] NULL ,
[conStatusDesc] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]