The balance will start when the case opens, this will be in an audit tab, the DB will auto fill with Open.

The Case will close when Close appears in the...

Calander Table ok thanks will look at that.

OK my posting is wrong

Date: ...

Jon, are you permitted to create/amend stored procedures? What about tables?

Why does the code have to be run twice per second when the returned values will change little in that...

I am not a SQL expert just things I have picked up to do simple queries.

I don't know about connection pooling either, but I will read up on it

SELECT upvolume,downvolume,TotalTrades

INTO #TodayRecords

FROM DBVaskVbid WITH (NOLOCK) -- are you fully awre of what this hint does?

WHERE BarStamp >= '7/14/2010'

-- do you have huge vlume of records per...

SQL messaging

Without drop table I can only run once

SQL Server Execution Times:

CPU time = 32 ms, elapsed time = 23 ms.

(1 row(s) affected)

SQL Server Execution Times:

CPU time = 15 ms, ...

I am running the query from Chris, it does not take long, not sure how long but I do notice some delay.

I keep the connection open at the moment, so...

Thank you very much, I was having trouble with permissions on that query as I connect remotely to SQL

there will be approx 58,000 records a day and be called 2...

drop table #TodayRecords

Is this the fastest way, i will have over a 100 lines and will be calling sql every 500ms?

Really sorry about this,

But I can only run the query once

Msg 2714, Level 16, State 6, Line 1

There is already an object named '#TodayRecords' in the database.

I would like...

Thank you for that Lynn

I was sending the SQL statement from another application, but I will add that to my list of statements in SQL

Find the highest figure of totaltrades for today

Subtract 1000 from that figure.

yes it is that simple

very sorry i can see me error now

There will be gaps but it matters little, i only need to get the data the same way every time

The same with duplicates, it wont affect the hi and low

Many...

I have data that I want to find the Min and Max off, for 2 fields

Upvolume and DownVolume

Every day the Totaltrades field starts at zero and cumulates throughout the day,...