so there is no way of running a query every 1 second from withn sql?

the sql database is tracking stockmarket volume's traded on stocks.

And is for use in a charting package

excel is likes the charting package to sql via a query

so i use excel...

sorry I am running express 2005 edition

any advise please?

Jon

ok solved it

so i dont think i need inner join just then between

rsRecordset3.Open "SELECT AVG(s.ESDSTotal) AS ESDSTotal FROM dbo.DemandSpread s BETWEEN DATEADD(mi, -1, " & "'" & DSMAXTS & "'" & ")...

These 2 statements work its the between statement thats not

So I find it here:

rsRecordset7.Open "select TIMESTAMP from DEMANDSPREAD WHERE TIMESTAMP=(SELECT MAX(TIMESTAMP)FROM DEMANDSPREAD)",

gcnConnect

DSMAXTS = rsRecordset7.Fields(0).Value

rsRecordset7.Close

and add it into the statement:

rsRecordset.Open "select...

I record it as a string so its works on the first statement as I send thru the where timestamp statement as a string, which matches the timestamp in sql...

ok thanks

I am running a few queries from excel into sql on a timed bases i open and close each one before the next, how does an index work over a...

i could fill what i know on a stamp

rsRecordset.Open "select ESDSTotal,ER2DSTotal,ESASKSIZE,ESBIDSIZE,ER2ASKSIZE,ER2BIDSIZE,ER2RATIOASK,ER2RATIOBID,ESRATIOASK,ESRATIOBID,ESNETR,ER2NETR from DEMANDSPREAD WHERE TIMESTAMP=(SELECT MAX(TIMESTAMP)FROM DEMANDSPREAD)", gcnConnect

Sheet1.Range("A15") = rsRecordset.Fields(0).Value

Sheet1.Range("B15") = rsRecordset.Fields(1).Value

...

is there a way of looking at memory usage with out perfmon

How much memory do you have on your server? 2GB , by the end of the day is normally 1gb still free

What service pack of SQL 2005 do you have?...

so i execute that query inside sql server only once?

can i create a index without a t-sql statement?

nad how will that change my query to search?

this time on setup i set all users to dbo, i think previously i clicked a different button on setup and had logins with different perms on the data base,...